activity 1.3.4.2

Adejimi
Contributor

activity 1.3.4.2

Hi Team,

 

Any idea why after importing, the code column is not populating even with the formular 

 

Adejimi_0-1658895039944.png

Or does it have to be manually inserted, I realized this activity is preventing me from completing activity 1.3.10.2.

2 REPLIES 2
rishabh01
Frequent Contributor

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.

ankit_cheeni
Super Contributor

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 CodeCountry NameParent
USUSAMER
CACanadaAMER
MXMexicoAMER
BRBrazilAMER
GBUKEMEA
FRFranceEMEA
ESSpainEMEA
DEGermanyEMEA
ITItalyEMEA
AUAustraliaAPAC
NZNew ZealandAPAC
INIndiaAPAC
JPJapanAPAC

 

ankit_cheeni_0-1658911772591.png

 

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.