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
mraka9's avatar
mraka9
Helper III
3 years ago

Hello Tom,

can you customize the function?
Column B is in text form for me. It is not necessary to change the garden in operation.

Although everything in the example is mostly shown as a number, there is also text.

Apologies and thank you very much in advance!

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

    Thanks Tom!
    I will try to do it that way, I hope it will work then.
    nice greetings,

  • 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