Discussion Board for collaboration on QlikView Scripting.
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!
Go to 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....
Thanks Jason - this works perfectly!