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

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

Fri, 15 Jan 2016 09:42:45 GMT

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

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

jonathandienst — Fri, 15 Jan 2016 10:06:15 GMT

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.

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

vinayr67 — Fri, 15 Jan 2016 11:01:58 GMT

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

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

Fri, 15 Jan 2016 11:38:15 GMT

Thanks. That worked!