Forum Discussion
OneWithQuestion
Post Prodigy
Post ProdigyDirect Query- multiple column relationships?
Our vendor system that we are using as a data source has several tables that use a combination primary key and for relationships to other tables you have to join on 3 or 4 columns (I hate it, I do no...
Hi OneWithQuestion,
In Direct Query, you are still able to create a calculated column to combine multiple columns to generate the primary Key.
Col4 = Test5[Col1]&" "&Test5[Col2]
ColC = Test6[ColA]&" "&Test6[ColB]
Best regards,
Yuliana Gu
This is true and can be done, although is not very performant as the query is no longer hitting the actual column predicates for the join, right?
kdohertyAdvocate I
Agree. It is isn't practical to do it with large tables. The database ends up scanning the whole table to find the artificial keys it needs.