Hello,
I have a table with two columns in a table with data like:
Col1 Col2
1 13172
1 13934
1 15030
1 15544
1 16007
1 16326
1 16357
1 17153
...
...
...
I want to expand this table with data from 4 other tables (t1-t4) which contain the above two columns + other attributes.
My output should look like the sample below (which is tab-delimited)
Col1 Col2 t1.col t2.col t3.col t4.col
1 13172 t1.*
1 15030 t1.* t2.* t3.*
1 13172 t2.* t4.*
1 13934 t2.* t3.*
1 15030 t1.* t2.* t3* t4.*
1 15544 t2.* t3*
1 16007 t1.* t3.*
....
....
....
Thank you for your help!
~Mika
I have a table with two columns in a table with data like:
Col1 Col2
1 13172
1 13934
1 15030
1 15544
1 16007
1 16326
1 16357
1 17153
...
...
...
I want to expand this table with data from 4 other tables (t1-t4) which contain the above two columns + other attributes.
My output should look like the sample below (which is tab-delimited)
Col1 Col2 t1.col t2.col t3.col t4.col
1 13172 t1.*
1 15030 t1.* t2.* t3.*
1 13172 t2.* t4.*
1 13934 t2.* t3.*
1 15030 t1.* t2.* t3* t4.*
1 15544 t2.* t3*
1 16007 t1.* t3.*
....
....
....
Thank you for your help!
~Mika