Forum Discussion

mraka9's avatar
mraka9
Helper III
4 years ago
Solved

Linking related items within the same table-Power Query

I need help with Power Query. I have a table with columns: A, B and C Column A and C contain identical items to be linked. I want column C to check where everything is in column A and show concate...
Need Help
TomMartens's avatar
TomMartens
Super User
3 years ago

Hey mraka9 ,

change this line

, each Number.ToText( _ )

to this

, each  _


Regards,

Tom

mraka9's avatar
mraka9
Helper III
3 years ago

Greeting,
it's amazing but I'm still struggling with this problem. You have found a solution but when I try to apply it to my large database I have a problem. I don't know if the problem is that everything is in Croatian...
When I add a custom column as you said, the column is created for me and it says "Function".

I don't know what I'm doing wrong.

 

This is the code I entered:

= Table.AddColumn(#"Dupliciran stupac1", "Prilagođeno", each ( row ) =>
let
filtervalue = row[#"Kataloški broj i ponuditelj - kopija"],
combinedString =
Text.Combine(
List.Transform(
Table.SelectRows( #"Dupliciran stupac1" , each [Kataloški broj i ponuditelj] = filtervalue) [#"Kataloški broj i ponuditelj-srodni"]
, each _
)
, ";")
in
combinedString)

 

REMARK:

In the example I added that the columns are called A B and C, but in reality they are columns:

A = Kataloški broj i ponuditelj
B = Kataloški broj i ponuditelj-srodni
C = Kataloški broj i ponuditelj - kopija

 

Thank you very much in advance