Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi all,
Looking at following dilemma, would appreciate any advice how to achive that.
I have one table which is fetching values from external data source, let's call this table MainTable:
Some ID Number | Some Data | More Data |
1234567 | AAA | 58 |
2345678 | BBB | 78 |
3456789 | CCC | 86 |
7890123 | DDD | 53 |
Then there is another 3 tables which is fetching data from another source and then appends then into 1 joined table CombinedTable , where ID values can match values from MainTable, for example:
Some ID Number | Some Data | More Data |
4567890 | EEE | 90 |
3456789 | CCC | 86 |
5678901 | FFF | 33 |
2345678 | BBB | 78 |
What is easiest and most efficient way to compare values which exist in MainTable to values in CombinedTable and keep them only if they are in MainTable , i.e final result should be:
Some ID Number | Some Data | data |
3456789 | CCC | 86 |
2345678 | BBB | 78 |
So in the nutshell, commom denominator for filtering would be always ID value from MainTable since CombinedTable would always contain signifcatly more values which are not needed.
Thanks a lot for any ideas!
Solved! Go to Solution.
Hi,
You can merge your CombinedTable with MainTable using JoinKind Inner
You obtain this
Then you can remove column MainTable
If this post is useful to help you to solve your issue consider giving the post a thumbs up
and accepting it as a solution !
Hi,
You can merge your CombinedTable with MainTable using JoinKind Inner
You obtain this
Then you can remove column MainTable
If this post is useful to help you to solve your issue consider giving the post a thumbs up
and accepting it as a solution !
Thanks, but it won't make any issues since real tables I have are way more complex and contain a lot of relationships and are merged themselves?
User | Count |
---|---|
91 | |
77 | |
71 | |
65 | |
58 |
User | Count |
---|---|
103 | |
94 | |
75 | |
61 | |
58 |