Forum Discussion

krekandus's avatar
krekandus
Regular Visitor
3 years ago

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...
Need Help
RichardJ's avatar
RichardJ
Responsive Resident
3 years ago

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 row

Click ok

 

Output

 

Cheers,
Richard

krekandus's avatar
krekandus
Regular Visitor
3 years ago

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