IMPORT failing - Not sure WHY?
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?
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.
@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?0
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.
Your target module has not dimensionality and only includes line items.
Add a relevant dimension and map a column from your source to it.0