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.
0 -
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!
0