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
After seven months and no activity on the performance issue that this approach of merge can cause.