Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
sarahallen1
Creator II
Creator II

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

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

1 Solution

Accepted Solutions
Jason_Michaelides
Luminary Alumni
Luminary Alumni

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

View solution in original post

3 Replies
Jason_Michaelides
Luminary Alumni
Luminary Alumni

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
Creator II
Creator II
Author

Thanks Jason - this works perfectly!

Jason_Michaelides
Luminary Alumni
Luminary Alumni

Coolio.