Can someone help me figure out what formula I need here? All the columns are filled. What am I missing?
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
Thanks for this! I understand the concepts but I am still struggling with this specific problem.
Not sure I understand what your question is. Can you clarify? The images don't seem to help me.
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?
@sydneygouani
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.
This is why I asked this question. I am not sure. The code was imported from the CSV file given.
I
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.
is the code row correct
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 ?
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!!
Just figured it out! Thanks anyway!
This is what I tried.
But there is no results.
Why is that?
@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!
I am also confused. The SKU.csv contains the code which I mapped in the import. So the formula to match the code seems redundant. it has been 3 weeks since i did the first part of this sprint, so perhaps there was a reason for it ??
Keep following instructions. Product and distribution center is next
There was an error rendering this rich post.
Hi all, The Client ID and Client Secret are available, intended for uploading and downloading files. Could anyone advise how to use these credentials DIRECTLY to make API requests? Thank you!
I have A6 as the parent list and two sibling lists: A6.5 and A7. The A7 list includes an attribute that maps to A6.5. In the UX, the user will select A6.5 using a content selector, and the grid (dimensioned by A7) should display only the A7 items associated with that selected A6.5. Since the selector is a page context and…
