Skip to main content
Announcements
Qlik Connect 2025: 3 days of full immersion in data, analytics, and AI. May 13-15 | Orlando, FL: Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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

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

1 Solution

Accepted Solutions
jonathandienst
Partner - Champion III
Partner - Champion III

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.

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein

View solution in original post

3 Replies
jonathandienst
Partner - Champion III
Partner - Champion III

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.

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
vinayr67
Contributor II
Contributor II

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

Capture.JPG

Regards,

Vinay

Not applicable
Author

Thanks. That worked!