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...
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