QlikView App Dev

[sarahallen1]

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

[Jason_Michaelides · Accepted solution]

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

[sarahallen1]

Thanks Jason - this works perfectly!

[Jason_Michaelides]

Coolio.