Missing data when importing flat file

Options
fredrickstraube
fredrickstraube Member, ALL USERS, Partner, Certified Model Builder Posts: 5 Frequent Contributor
in Extensibility

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 CategoryProduct
Catregory AProduct A
 Product B
 Product C
Category BProduct D
 Product E
 Product F
Category CProduct 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!

Tagged:

Comments

  • fredrickstraube
    fredrickstraube Member, ALL USERS, Partner, Certified Model Builder Posts: 5 Frequent Contributor

    Hi Rob,

    Thanks a lot for your answer, however, I don't really see how this would help me in this case. Could you perhaps clarify a little?

    A manual mapping modules is not an option since I have several hundred list items and a three level hierarchy to build.

    //Fredrick 

Categories