1.4.3.2 Import Data & Add Formula

[sydneygouani]

Can someone help me figure out what formula I need here? All the columns are filled. What am I missing?

[chofacker]

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

[sydneygouani]

Thanks for this! I understand the concepts but I am still struggling with this specific problem.

[chofacker]

Not sure I understand what your question is. Can you clarify? The images don't seem to help me.

[sydneygouani]

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?

[FahuaXu]

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.

[ChrisAHeathcote]

@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.

使用这个组合函数的代码和项目tions to return the code.

[ChrisAHeathcote]

Also, are you sure that is the correct code for the combination list?

[sydneygouani]

This is why I asked this question. I am not sure. The code was imported from the CSV file given.

I