Forum Discussion
merge or vlookup
Hi Team,
I have two different table and I don't know how to get Table 1 ID column merge to Table 2.
Table 2 I'm expecting ID, can you help me.
Final output look like below , Table 1 ID fetching Table 2 based on 3 columns (case, copper min vs status)
Thanks,
KV's
- Hey, @Udt_KVWhat effect do you expect to have?If possible, further describe your requirements or provide sample data, so you can provide more help.
Hi, Anonymous
Thank you for your feedback.
After my attempts, I have successfully achieved the result you wanted.
The following is my method for your reference.
You can use the Unpivot Columns feature in Query Editor
Sample data:
I create a copy of Table 1 and rename it to table 1_unpivot, then perform an unpivot operation on that copy
Here are the results of the operation:
Then create a relationship between “table 1_unpivot” and “table 2”
Finally we create table visual,
Result:
Using filter to remove null value to get the final result.
Is this the result you want? Hope this is useful to you.
Please feel free to let me know If you have further questions.
Best Regards,
Community Support Team _ Zeon Zheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
11 Replies
- selimovd
Most Valuable Professional
Hey Anonymous ,
you need some criteria that matches in order to merge them.
In which row of table 2 should ID 1 appear? If you can explain that I can help you.
If you need any help please let me know.If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍Best regardsDenisBlog: WhatTheFact.bi - v-angzheng-msft
Community Support
Hi, AnonymousWhat effect do you hope to get?If possible, please further describe your requirements or provide sample data, so that I can provide you with further help.- v-angzheng-msft
Hi, Anonymous
Thank you for your feedback.
After my attempts, I have successfully achieved the result you wanted.
The following is my method for your reference.
You can use the Unpivot Columns feature in Query Editor
Sample data:
I create a copy of Table 1 and rename it to table 1_unpivot, then perform an unpivot operation on that copy
Here are the results of the operation:
Then create a relationship between “table 1_unpivot” and “table 2”
Finally we create table visual,
Result:
Using filter to remove null value to get the final result.
Is this the result you want? Hope this is useful to you.
Please feel free to let me know If you have further questions.
Best Regards,
Community Support Team _ Zeon Zheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Syndicate_AdminAdministrator
Hey, @Udt_KVWhat effect do you expect to have?If possible, further describe your requirements or provide sample data, so you can provide more help.- Syndicate_AdminHey, @Udt_KVWhat effect do you expect to have?If possible, further describe your requirements or provide sample data, so you can provide more help.
- Syndicate_AdminHey, @Udt_KVWhat effect do you expect to have?If possible, further describe your requirements or provide sample data, so you can provide more help.
- Syndicate_AdminHey, @Udt_KVWhat effect do you expect to have?If possible, further describe your requirements or provide sample data, so you can provide more help.
- Syndicate_AdminHey, @Udt_KVWhat effect do you expect to have?If possible, further describe your requirements or provide sample data, so you can provide more help.
- Syndicate_AdminHey, @Udt_KVWhat effect do you expect to have?If possible, further describe your requirements or provide sample data, so you can provide more help.
- Syndicate_AdminHey, @Udt_KVWhat effect do you expect to have?If possible, further describe your requirements or provide sample data, so you can provide more help.
