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

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)

Screenshot 2022-01-27 at 20.31.56 (2).png

Many thanks in advance.

Accepted answers

ManjunathKN

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)
fixed line item -->line items

your import should work

Thanks,
Manjunath

All comments

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

ManjunathKN

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.

but 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

@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

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

zaibhamid81

Thank you @ManjunathKN for 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

ManjunathKN

zaibhamid81

Thanks so much @ManjunathKN it worked.

Quick Links

Can you help?

Unanswered questions

別ディメンションで、セレクターをモジュールに返し、計算したい
下記のようなことがしたいですコンテキストセレクターの値を別モジュールに反映し、それを使って計算したいです。 selecter A-1 Dim code amount Select→ A-1 1 100 A-2 2 100 A-3 3 100 A-4 4 100 module Dim code amount key Flg A-1 1 1 25 A-1 TRUE 1 1 25 A-1 TRUE 1 1 25 A-1 TRUE 1 1 25 A-1 TRUE 2 2 50 A-2 FALSE 2 2 50 A-2 FALSE
Importing Ragged Hierarchies
Hello - I have a 2 level ragged hierarchy (yes, it's a chart of accounts), that for reporting purposes is used in 4 different models (yes, it's a P&L). What is the best way set this to allow one to be the "source of truth" and then import between the four models without creating actions that include ignores? It seems like…
Where can I find export file after running export process using machine task in a workflow?
I am testing export actions using workflow but its not generating any file when I am running the workflow, but the same process is generating export file when ran from the Actions→Process section. Is their any issue with the workflow functionality? Also, If I want to generate a file after completion of workflow and pull…