Table with all keys

[Anonymous]

Hello,

i have 10 tables as sources.

I want to make a table with all the key in it.

¿how could it be done?

[ahaahaaha]

Hi Pablo,

Too general description of the task. Without the source data it is very difficult to help.

Regards,

Andrey

[stabben23]

Search for "create linktable" or similar.

[PrashantSangle]

Hi,

Are you looking for link table???

search for link table on community.

Regards,

Prashant

[PrashantSangle]

or using concatenate you can create one table.

solution1:

table1:

Load key1,t1_field1,t1_field2 from table1;

table2:

Load key2,t2_field1,t2_field2 from table2;

table3:

Load key3,t3_field1,t3_field2 from table3;

link_table:

Load key1 from table1;       // You can use resident load also but if data is huge then resident load is performance killer

concatenate

Load key2 from table2;

concatenate

Load key3 from table3;

solution 2: One table

table1:

Load key1,t1_field1,t1_field2 from table1;

concatenate

Load key2,t2_field1,t2_field2 from table2;

concatenate

Load key3,t3_field1,t3_field2 from table3;

Regards,

Prashant

[ramasaisaksoft]

if you want to see all the fields and tables use a table box and call system fields ( $Table,$Fields) it will gives all Tables & fields  as you mentioned Tables names in that script.

[priyasawant · Accepted solution]

Kindly create a link table of all the keys of different tables.

You can go through the below links for further clarification.

https://community.qlik.com/thread/132848

Linking Tables in Qlikview