Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
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.
@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.
Click ok
Cheers,
Richard
I made it,
1. Read data from excel
2. create two reference on first step
3. first reference have min value QMIN
4. second reference hva max value QMAX
5. Merge QMIN Left Outer Join QMAX
6 In new table I get wrigth values from QMAX
This is frist Query:
QMIN:
QMAX:
From bouth Query remove last two columns, and Attribute Split with "/" separator and replace QMIN with START and QMAX with END:
QMIN:
QMAX:
Merge LEft outer JOin
First Row tabel values:
Everthing is nice with problems.
But After Expand last row, get same Value as from QMIN query:
I schould get from QMAX Value, which is Ok in step before Expand.
I get here same VAlue from QMIN Value column.
Bet regards
How it looks in tables:
Its wrong after merge, green is ok red is wrong
hier should You find file PBIX
https://drive.google.com/drive/folders/1tOzSgK8gANfLMQ5YNLsBfdrMVpvccnLK?usp=sharing
User | Count |
---|---|
140 | |
113 | |
104 | |
73 | |
63 |
User | Count |
---|---|
135 | |
126 | |
110 | |
70 | |
61 |