topic Can you create a script table which is like a table box object with all fields included? in QlikView

Can you create a script table which is like a table box object with all fields included?

sarahallen1 — Tue, 03 Apr 2012 10:37:09 GMT

I want my data structure, as shown in the table viewer, to be the simple (albeit inefficient) structure achieved by creating a table box object and inserting all fields.

Is there a quick way of doing this (replacing the existing script tables with this new single table)? Or would I have to fiddle around with left joins / concatenations etc?

Thanks very much!

Sarah

Can you create a script table which is like a table box object with all fields included?

Jason_Michaelides — Tue, 03 Apr 2012 10:42:20 GMT

I think you'd have to do something like this at the end of your script:

JOIN (Table1) LOAD * RESIDENT Table2;

JOIN (Table1) LOAD * RESIDENT Table3;

JOIN (Table1) LOAD * RESIDENT Table4;

JOIN (Table1) LOAD * RESIDENT Table5;

JOIN (Table1) LOAD * RESIDENT Table6;

DROP TABLES Table2, Table3, Table4, Table5, Table6;

Should do it....

Can you create a script table which is like a table box object with all fields included?

sarahallen1 — Tue, 03 Apr 2012 11:10:40 GMT

Thanks Jason - this works perfectly!

Can you create a script table which is like a table box object with all fields included?

Jason_Michaelides — Tue, 03 Apr 2012 11:12:47 GMT

Coolio.