Forum Discussion
Solved
Multiple values when expanding merged queries.
Hello Community! I have issues when expanding one value from merging queries. Ut causes several duplicates on my grouped rows. I have done a pivoted column and I have only one value per Machine/Arti...
I found that when merging queries I can use several columns to match data, solved my issue!
This typically happens when the columns you are joining on has duplicates. If the column (you are joining/merging on) has duplicates, it will result in a cross join and give multiple values. Check the joining column for duplicate values. There should be unique values in such columns
I found that when merging queries I can use several columns to match data, solved my issue!