Hi Team,
Any idea why after importing, the code column is not populating even with the formular
Or does it have to be manually inserted, I realized this activity is preventing me from completing activity 1.3.10.2.
Hi @Adejimi
I think the issue is with your country flat list used in the formula.
There must be a hierarchical list of country present in the system, which I believe, ideally should be used as a dimension in this SYS06 module.
So you have a hierarchical list as a dimension in SYS06 and you should pull values from that hierarchical list only.
Thanks,
Rishabh.
Hi @Adejimi
Good thing is your formula is correct, no problems there.
Anaplan is extremely logical so when something doesn't work, it usually guides you where to go. In this case since code isn't showing up and your formula is correct, you can be sure that code is not present in the Country Flat list.
The csv to be imported has three columns, make sure when you are importing into the list, you are mapping name to Country Name and code to Country code. I can see you have mapped Country code to name in the list (This would've happened since you did not change the import mapping and went with the default).
Country Code | Country Name | Parent |
US | US | AMER |
CA | Canada | AMER |
MX | Mexico | AMER |
BR | Brazil | AMER |
GB | UK | EMEA |
FR | France | EMEA |
ES | Spain | EMEA |
DE | Germany | EMEA |
IT | Italy | EMEA |
AU | Australia | APAC |
NZ | New Zealand | APAC |
IN | India | APAC |
JP | Japan | APAC |
Note that you'd need to delete all items from Country Flat list first and then re-import to ensure you get the data right.