topic Re: 1.4.3.2 Import Data & Add Formula in Anaplan Platform https://community.anaplan.com/t5/Anaplan-Platform/1-4-3-2-Import-Data-amp-Add-Formula/m-p/124668#M31426 < P >方向让我创建一个新模块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?

 Thu, 11 Nov 2021 22:26:30 GMT sydneygouani 2021-11-11T22:26:30Z 1.4.3.2 Import Data & Add Formula https://community.anaplan.com/t5/Anaplan-Platform/1-4-3-2-Import-Data-amp-Add-Formula/m-p/124654#M31418

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

 Thu, 11 Nov 2021 17:55:08 GMT https://community.anaplan.com/t5/Anaplan-Platform/1-4-3-2-Import-Data-amp-Add-Formula/m-p/124654#M31418 sydneygouani 2021-11-11T17:55:08Z Re: 1.4.3.2 Import Data & Add Formula https://community.anaplan.com/t5/Anaplan-Platform/1-4-3-2-Import-Data-amp-Add-Formula/m-p/124656#M31419

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

 

 Thu, 11 Nov 2021 18:39:28 GMT https://community.anaplan.com/t5/Anaplan-Platform/1-4-3-2-Import-Data-amp-Add-Formula/m-p/124656#M31419 chofacker 2021-11-11T18:39:28Z Re: 1.4.3.2 Import Data & Add Formula https://community.anaplan.com/t5/Anaplan-Platform/1-4-3-2-Import-Data-amp-Add-Formula/m-p/124665#M31423

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

 Thu, 11 Nov 2021 21:58:56 GMT https://community.anaplan.com/t5/Anaplan-Platform/1-4-3-2-Import-Data-amp-Add-Formula/m-p/124665#M31423 sydneygouani 2021-11-11T21:58:56Z Re: 1.4.3.2 Import Data & Add Formula https://community.anaplan.com/t5/Anaplan-Platform/1-4-3-2-Import-Data-amp-Add-Formula/m-p/124667#M31425

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

 Thu, 11 Nov 2021 22:00:59 GMT https://community.anaplan.com/t5/Anaplan-Platform/1-4-3-2-Import-Data-amp-Add-Formula/m-p/124667#M31425 chofacker 2021-11-11T22:00:59Z Re: 1.4.3.2 Import Data & Add Formula https://community.anaplan.com/t5/Anaplan-Platform/1-4-3-2-Import-Data-amp-Add-Formula/m-p/124668#M31426 < P >方向让我创建一个新模块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?

 Thu, 11 Nov 2021 22:26:30 GMT https://community.anaplan.com/t5/Anaplan-Platform/1-4-3-2-Import-Data-amp-Add-Formula/m-p/124668#M31426 sydneygouani 2021-11-11T22:26:30Z Re: 1.4.3.2 Import Data & Add Formula https://community.anaplan.com/t5/Anaplan-Platform/1-4-3-2-Import-Data-amp-Add-Formula/m-p/124669#M31427

 

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.

 Thu, 11 Nov 2021 23:19:26 GMT https://community.anaplan.com/t5/Anaplan-Platform/1-4-3-2-Import-Data-amp-Add-Formula/m-p/124669#M31427 ChrisAHeathcote 2021-11-11T23:19:26Z Re: 1.4.3.2 Import Data & Add Formula https://community.anaplan.com/t5/Anaplan-Platform/1-4-3-2-Import-Data-amp-Add-Formula/m-p/124670#M31428 Also, are you sure that is the correct code for the combination list? Thu, 11 Nov 2021 23:20:35 GMT https://community.anaplan.com/t5/Anaplan-Platform/1-4-3-2-Import-Data-amp-Add-Formula/m-p/124670#M31428 ChrisAHeathcote 2021-11-11T23:20:35Z Re: 1.4.3.2 Import Data & Add Formula https://community.anaplan.com/t5/Anaplan-Platform/1-4-3-2-Import-Data-amp-Add-Formula/m-p/124748#M31451

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

 

I

 Fri, 12 Nov 2021 16:54:57 GMT https://community.anaplan.com/t5/Anaplan-Platform/1-4-3-2-Import-Data-amp-Add-Formula/m-p/124748#M31451 sydneygouani 2021-11-12T16:54:57Z Re: 1.4.3.2 Import Data & Add Formula https://community.anaplan.com/t5/Anaplan-Platform/1-4-3-2-Import-Data-amp-Add-Formula/m-p/132760#M34250

Thank you ! Combined with CODE() and Item() syntax, the answer to this question should be CODE(Item(SKU Flat)) and it works for me.

 Wed, 23 Feb 2022 12:47:51 GMT https://community.anaplan.com/t5/Anaplan-Platform/1-4-3-2-Import-Data-amp-Add-Formula/m-p/132760#M34250 FahuaXu 2022-02-23T12:47:51Z