IMPORT failing - Not sure WHY?

CommunityMember126793

Hi All, I am unsure why the Import is failing whilst import into dimensioned / non-dimensioned module..

Import snippet: 1st & 3rd columns are List Item Property

Whilst Import it is failing due to duplicate values:

The final output in module is the consolidated values of all number types..

Screenprint from BluePrint (not included all the lineitems):

Can anyone help in getting it fixed?

Accepted answers

All comments

LipChean_Soh

Hi @CommunityMember126793

I think you're missing a list in your module. Sales perhaps?

After you've done that, you'll see another mapping option available to you.

Thanks,

LipChean

CommunityMember126793

@LipChean_Soh , hi

I have tried that load in the dimensioned module with the List "Sales Rep" (e.g. D1, D2, D3 etc.) but still the same error..

All I am trying is to pull in the below data:

Sales Rep Number	Dealer Name	Expense Account	Service Elements	Commission Amount	OIC Commission Amount
D1	Dealer 1	1-1	ABC	0.5	10.22
D1	Dealer 1	2-2	SDD	28	10.22
D1	Dealer 1	2-2	DDD	105	10.22
D1	Dealer 1	3-3	RRR	3.08	10.22
D1	Dealer 1	1-1	DFT	0.5	10.22
D1	Dealer 1	2-2	FRR	104.5	10.22
D1	Dealer 1	4-4	YYY	-1	10.22
D1	Dealer 1	3-3	GTH	49.5	10.22
D2	Dealer 2	5-5	TYU	320.7379	11.22
D2	Dealer 2	6-6	TTT	652.2845	11.22
D3	Dealer 3	6-6	PPP	29.2605	11.26
D3	Dealer 3	3-3	WEP	2.805	11.26

Can u help with the steps?

LipChean_Soh

Hi @CommunityMember126793

Previously, you can only see 1 row of mapping as shown below.

Once you have Sales Rep in your module, there should be another mapping required for your loading action. You can then map 'Sales Rep Number' in your data file to the 'Sales Rep' in your module.

Thanks,

LipChean

ChrisAHeathcote

@CommunityMember126793

Your target module has not dimensionality and only includes line items.

Add a relevant dimension and map a column from your source to it.

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…