Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
i have 10 tables as sources.
I want to make a table with all the key in it.
¿how could it be done?
Kindly create a link table of all the keys of different tables.
You can go through the below links for further clarification.
Hi Pablo,
Too general description of the task. Without the source data it is very difficult to help.
Regards,
Andrey
Search for "create linktable" or similar.
Hi,
Are you looking for link table???
search for link table on community.
Regards,
Prashant
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
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.
Kindly create a link table of all the keys of different tables.
You can go through the below links for further clarification.