1.4.3.2 Import Data & Add Formula
Can someone help me figure out what formula I need here? All the columns are filled. What am I missing?
Answers
-
Hi!
Check out these two links. They should help.
https://help.anaplan.com/0e20099c-af47-4343-9ad9-3a20b580d2de-CODE
https://help.anaplan.com/e9d3a937-dae7-4091-9ef4-a1f48f0dd7a4-ITEM
1 -
Thanks for this! I understand the concepts but I am still struggling with this specific problem.
0 -
Not sure I understand what your question is. Can you clarify? The images don't seem to help me.
0 -
The directions asked me to make a new module to import all the data. Then it says to create a formula for the "Code" column. I am not clear why I am making a formula because the "Code" column is filled. Can you give me some insight as to the logic behind adding a formula? Where do I start?
1 -
If you recall from Level 1 there is a formula that can be used to derive the code of the list which is dimensioned in the module.
Use this combination of CODE and ITEM functions to return the code.
0 -
Also, are you sure that is the correct code for the combination list?0
-
This is why I asked this question. I am not sure. The code was imported from the CSV file given.
I
0 -
Thank you @chofacker! Combined with CODE() and Item() syntax, the answer to this question should be CODE(Item(SKU Flat)) and it works for me.
1 -
is the code row correct
0 -
On this task, it was requested to import the Products but in the CSV file, we dont have any products data, hen ce I couldnt post it? Did I miss something ?
0 -
I am having the same question as you @dtnguyen
Did you find out what is going on and what we are supposed to do?
Thanks!!
0 -
Just figured it out! Thanks anyway!
1 -
This is what I tried.
But there is no results.
Why is that?
0 -
@dpong8898 - the code formula you entered did return code values of sku flat list into the 'code' lineitem. That much worked.
As the next step, you must load data into 'products flat' list and 'location flat' list from respective csv files first. And then you can use 'SKUs.csv' file to load those details per SKU into SYS12 module through an import action.
Cheers!1
