L1 Model Building 8.5.3 Activity: Import Data into Volume Inputs Module

[zaibhamid81]

Hi Everyone,

Could someone please advise how to map this data in L1 MB activity 8.5.3.

Please see the screenshot, I have tried time with Column header and then mapping time values manually in the time tab but it fails to map all values ( 36 values failed)

Many thanks in advance.

[bhatjaved]

@zaibhamid81

Map Time with headers ,P2 products with product code , G3 location with location code and fixed line where you will select volumes . Ensure your formatting for time is correct and then re-run the action .

Also you need to bear in mind that headers lie in 2nd row and data in 3rd row

[zaibhamid81]

@bhatjaved

Thanks for your reply.

Could you please explain how can choose column headers in 2nd row, what are the steps so Anaplan recognize that my headers are in 2nd row and data starting from the 3rd row .

Many thanks

[bhatjaved]

@zaibhamid81Import the file again and once you get the below screen change your rows accordingly

[ManjunathKN123]

Hi

this is the mapping tab, initially you will get the import data source tab. where in you have marked it as header as 1st row and data as 2nd row.

但in your source table you can see first row is fixed line item that is volume! so, your header will be 2nd row and data will start from 3rd row.

How to correct this:you have to import the file again either in grid or import data source, it will show import data source tab and mark header as 2nd row and data as 3rd row.

Hint for future mapping: your volume is fixed line item in the source.

Thanks,
Manjunath

[zaibhamid81]

Thank you@ManjunathKN123for you reply,

Are you talking about this page, if this is the page you are talking about to map the data then please let me know how to select rows to tell Anaplan where my column headers starting ( it is only showing column option please see the below screenshot)

Many thanks.

Zeb

[ManjunathKN123 · Accepted solution]

Hi,

you have to import the file in grid view and not in blueprint view. you should select first header as 2nd row and first data as 3rd row.

In mapping
time --> column headers(and in time mapping tab, select periods and select YYYYMM)
固定的行项目——>行项目

your import should work

Thanks,
Manjunath

[zaibhamid81]

Thanks so much@ManjunathKN123it worked.