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,
I have a really annoying problem:
I'm trying to merge two queries and can't get the columns to match... to illustrate the problem I have reduced my tables to only two columns each and only three rows. Please see pictures:
I press "Merge Queries as New" and select Col 1 for both tables. No mather what options I choose from the "Join Kind" option I get 0 matching rows... Please see the next two pictures..
I believe this is due to some kind of formatting error but everything seems okay to me. Does somebody have any suggestions on how to trouble shoot this error!?
Thank you!!
Solved! Go to Solution.
Hi @Anonymous
Could there be some extra space after some text..?
For example "MRG " in one table ..."MRG" in another
You can use custom Column to check this
Text.Length([Col 1])
Hi @Anonymous
Could there be some extra space after some text..?
For example "MRG " in one table ..."MRG" in another
You can use custom Column to check this
Text.Length([Col 1])
User | Count |
---|---|
93 | |
87 | |
77 | |
72 | |
67 |
User | Count |
---|---|
116 | |
107 | |
88 | |
65 | |
63 |