how to load data into sub-products in line items.

RISINGSTAR

Hi All,

i am facing a small issue while loading actual data into line items.

we have two products category.

Products L1

Examples : TR,TW,UC.,,,

Sub Products L2

TR_M, TR_Q, TR_HY, TW_M, UC_M .,,,,,

Data file contains both products and sub-products can any one help me solve this. i am loading data via list to module.

getting errors in bellow.

1)Another row has already been processed with this key

2)Error in key for this row; refers to invalid list item: 3001

Thanks,

Uday

Accepted answers

Sheethal

Then create a unique key in your source file or while importing use combination of properties to get the row uniqueness.

All comments

Sheethal

You can load the data directly into the module instead of doing it via list, as the actuals data is multi dimensional and lists cannot store such data. This should solve your first issue.

Invalid list item error occurs when you are trying to load data into a list formatted property & the corresponding data is not found in that list.

RISINGSTAR

Hi Sheethal,
thanks for your response very quickly.
we can load directly via module but problem is we are bifurcating data into different modules using mapping to the list.

Thanks,

Sheethal

Then create a unique key in your source file or while importing use combination of properties to get the row uniqueness.

RISINGSTAR

Hi Sheethal,

can you please help me how to create unique key in source file .

Thanks,
Uday.

Harsha

Uday,

You can create unique key in source file by concatenating columns which makes unique and import it as code into list.

alexpavel

Hi Uday,

"Unique key" or "Primary Key" are concepts that are coming from relational database. You can find a lot of explanations/documentation on internet about these.

You can consider the data file that you want to load in Anaplan as a "table".

However, in order to identify a "unique key" of your file you need to answer this question:

What is the criteria to identify uniquely a row in the file ?

Is it already present a column that could identify uniquely a row in the file? (something like Invoice_ID ?)

If not, is there a combination of columns that could give as result a unique key of the file? ( example: Customer_ID + Product_ID + Date ?)

If you still do not have a positive answer after you concatenate all the columns of your file, then you need to return to the provider of the file and ask him/her to group (aggregate) the data based on the columns of the file in order to have a possible unique key of the file.

If you will have a "unique key" of the file then you will be able to use "Choose properties below to build the unique identifier for the imported items" option when import data in the numbered list without receiving any error.

Ciao

Alex

RISINGSTAR

Hi Alex,

Thanks for your response, I will check get back to you.

Thanks,

Uday.

Quick Links

Can you help?

Unanswered questions

How have you from-scratch built lot-level, geo-based Inventory Consumption?
We’re working on modeling inventory consumption at the lot level, accounting for shelf life considerations, since we need visibility into which lots may not consume—both for risk reporting and E&O analysis. Each item may have customers with different shelf life requirements. For example, item A may need 270 days for some…
How to bring Row data into Columns?
Hi, Can you help me, how can we get row data into columns using Unique ID? Per attached below first snapshot, I want to bring rountingOrder 4, RecipientName, Sent and Completed dates in 1 row as show in sanpshot 2. Do I need to create Hierarchy list and Map?
How to Design Simulation Planning in Anaplan with Multi-Level User Input and Step-by-Step Logging?
Hi Anaplan Community, I'm working on a simulation planning model where users need the flexibility to input pricing adjustments at any level of the product hierarchy, and I’d love your guidance on best practices. 📌 Scenario Overview: We have a 4-level product hierarchy: Brand Category Sub Category SKU (lowest level) The…