Concatenate lines

[spaiva]

I have a table in an Oracle database that stores several lines that refers to only one line in another table.

I would like to know if there is a way to transform this lines in one unique line.

The column YP_CHAVE is the key so I want to join the lines in YP_TEXTO where this key is the same.

Thanks in advance.

[mussaenda]

This means, YP_SEQ will be disregarded?

And you want it to do in power query?

[spaiva]

Yes, that's it.

[Anonymous]

@spaiva 

If I get you right, try: 

Column = CONCATENATE([YP_CHAVE],[YP_SEQ])

So for the new column you should have values like 000001001 for text data type,it might show 11 if they are numerical data type. But with either way,each role should be unique.

Paul Zheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[spaiva]

I need to join the lines where YP_CHAVE is the same. The values in column YP_TEXTO is brocken down in several lines.

So I want to make a group by YP_CHAVE and concatenate the lines in YP_TEXTO where YP_CHAVE  repeats.

Take a look in the example above. This 3 lines have to be one unique line because the YP_CHAVE is the same for all.

The column YP_SEQ shows where the message begins and end in YP_TEXTO.

[Tahreem24]

@spaiva ,

Try below DAX to get your requirement:

Column = CONCATENATE(Sheet1[Amount],LOOKUPVALUE(Sheet2[Amount],Sheet2[Name],Sheet1[Name]))

Don't forget to give thumbs up 👍 and accept this as a solution if it helped you.

[Tahreem24]

@spaiva , In my above post my key column is Name. So accordingly create your DAX.

Don't forget to give thumbs up 👍 and accept this as a solution if it helped you.