Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

sarahallen1
Contributor 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_michaelid
Honored Contributor II

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

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

3 Replies
jason_michaelid
Honored Contributor II

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

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
Contributor II

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

Thanks Jason - this works perfectly!

jason_michaelid
Honored Contributor II

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

Coolio.

Community Browser