topic Re: Table with all keys in QlikView

Table with all keys

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hello,

i have 10 tables as sources.

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

¿how could it be done?

Re: Table with all keys

ahaahaaha — Mon, 06 Mar 2017 13:44:07 GMT

Hi Pablo,

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

Regards,

Andrey

Re: Table with all keys

stabben23 — Mon, 06 Mar 2017 13:49:36 GMT

Search for "create linktable" or similar.

Re: Table with all keys

PrashantSangle — Mon, 06 Mar 2017 13:50:54 GMT

Hi,

Are you looking for link table???

search for link table on community.

Regards,

Prashant

Re: Table with all keys

PrashantSangle — Mon, 06 Mar 2017 13:59:09 GMT

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

Re: Table with all keys

ramasaisaksoft — Tue, 07 Mar 2017 05:10:44 GMT

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.

Re: Table with all keys

priyasawant — Tue, 07 Mar 2017 05:19:22 GMT

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