Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

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
MVP
MVP

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

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
3 Replies
MVP
MVP

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

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
vinayr66
New Contributor II

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

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

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

Thanks. That worked!