Working an import scenario for BOM details which include both header BOM information and materials on the BOM within the same Excel. The Excel file is set up which row type 0 including header information and row type 4-8 including the materials on the BOM.
How do I set up the import scenario so I populate the header level information (for example the BOM description) based on information sitting within the row for TYP = 0.
I’ve tried some IF statements but not achieving what I need.
Best answer by Laura02
Hello,
I noticed some prior posts related to import scenarios for BOM’s (1st one has attached XML’s). Have you already checked these out?
Laura
+19Hello,
I noticed some prior posts related to import scenarios for BOM’s (1st one has attached XML’s). Have you already checked these out?
Laura
Thanks
A quick read through that answered my question - here it is in case others have the same question:
You must have the header level information present in every row - in my example the Project Name field which represents the BOM description must be present in every row in your Excel/SQL.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
