Missing data when importing flat file

fredrickstraube

Hey!

I am facing an issue when it comes to a data import. I want to build lists based on a flat file, and I get the file from another system, so I do not have option to modify the source file.

The file structure is like the one below:

Product Category	Product
Catregory A	Product A
	Product B
	Product C
Category B	Product D
	Product E
	Product F
Category C	Product G
	Produgt H

Where Product A-C belongs to Category A, Product D-F to Category B and G-H to Category C.

My idea is to use product as unique identifier when importing into a technical import list, and then I have an import module where I import the data, to basically get the view above.

However, I need a way to assign the correct product category to the products where it is missing.

Would anyone know the best way to do this? Any help is appreciated 🙂

Thanks a lot!

EgeK

Hi fredrickstraube,

 

Anaplan will think that Product B and C belong to no category since it is empty in the table.

The blanks in that table will cause you problems. If you cannot change the file before it goes into Anaplan, I'd suggest importing the Category and Product List separately and manually create a mapping in a module or map the hierarchy depending on what will be more useful to you.

This isn't ideal since there is some manual work, but not being able to amend the flat file prior to the import is quite limiting. I'd be interested in what others will suggest.

 

Hope this helps!

Ege