Help with load script - loop to make a where used table

[#1]

Hi,

I am trying to make a table showing all items using a specific material and could need some help.

I have made a table listing all the BOM_Items in different columns.
What is the best load script to make a new table where all BOM items are combined into the same column?

See below example (excel file attached):

Thanks in advance!

Freddy

[jonathandienst · Accepted solution]

You could use a cross table load:

CrossTable(BOMItemNo, BOMItem)

LOAD *

FROM WhereUsedTable.xlsx

If the item number is not important, you could drop the BOMItemNo field at the end of the load.

[vinayr67]

I agree.

If you like to see how the code is constructed (especially for more complex cross table loads):

1.  Load your spreadsheet via the Table Files button

2.  Under the Options section of the File Wizard, Click on the Cross Table button

3.  You can now specify Qualifier Fields, Attribute Field, and Data Field

Regards,

Vinay

[#4]

Thanks. That worked!