Forum Discussion
Merge in Power query editor
Hello, I found one issue in Power Qury editor.
OK I have table 2 columns, USER_ID and NOTICE. in column NOTICE, exit data in following inetrface, {[timestamp] description} and it exist till 20 times separator is "||" double pipeline. I made following, create two same query with start, first have order Ascendnig an second have order descending, Column NOTICE splited with separator ||, get til 20 new columns, thouse columns unpivot and get:
USER_ID, Attribute, Value, in bouth query. Also group by USER_ID, set index in tables, and naow have two tables Attribute Ascending and second Descending. Expanded new tables, set filter INDEX=1. NOw I have in first query USER_ID and first column from NOTICE column, in second USER_ID and last column from NOTICE.
After that made merge first with second, get table when check data in table it looks fine:
After merge expand table I got same values:
Is it some issue in Editor or I made something wrong.
Best regards
7 Replies
krekandus
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.Sorry but I can not upload file, send me your mail, or describe how to upload file
krekandus you may know this allready but in case you don't, it might be easier to split your delimited values into rows prior to merging the columns.
This may help you resolve where the error is being introduced.
If you ensure 'Rows' is selected as shown below that will provide you with a new row for each value.
Split Delimiter in to new rowClick ok
Output
Cheers,
Richard
Hi krekandus,
It may be caused by your matching columns or join kinds.
About matching columns, you can select multiple columns at the same time.
For the choice of kinds to join, you can refer to the following:
Reference:
Merge queries (Power Query) - Microsoft Support
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
