Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello all,
I have two spreadsheets with with 4 common columns W,X,Y,Z
I am loading both spreadsheets in table A and B respectively.
When I load both the tables synthetic key is formed for W,X,Y,Z.
I want to remove the synthetic key. I am using all of the above 4 columns as filters so I cannot use Aliasing fields name.
Please suggest.
Thanks
then you you can use link table
Hi
If both tables have so much common columns, can you force concatenate both into 1
or
Rename fields & use hashkey instead to link the tables
or
You can break your tables into smaller
or..
PS: If you're data results/values are right, then synthentic key is not a problem
Thanks Govind,
Yes I can see the results are as expected as of now.
However I was worried if I got multiple spreadsheets to load then it would make data model a bit complex.
table 1 has total 21 columns and table 2 has total 11 columns.
I am not sure about haskey approach, I will explore it.
Regards,
Onkar