Forum Discussion

Alicia83B's avatar
Alicia83B
Helper I
4 years ago
Solved

Add Column based on VLOOKUP and CONCATENTATION

I am looking to add a new column based on looking up an opportunity number and concatentating the products from another column. A comma would be used to separate each Product Code.    Here is an ex...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi Alicia,

     

     Think this might give you the desired result (just check the column names first):

     

    = Table.Group(#"Renamed Columns", {"Opportunity"}, {{"Count", each Table.RowCount(_), type number},{"ProductCode", each Text.Combine([ProductCode],","), type text}})

     

Einomi's avatar
Einomi
Helper V
4 years ago

Hi,

Please try the following M code

 

let
    Source = Excel.CurrentWorkbook(){[Name="Tableau1"]}[Content],
    #"Type modifié" = Table.TransformColumnTypes(Source,{{"Opportunity #", Int64.Type}, {"Product Code", type text}}),
    Sort = Table.Group(#"Type modifié", {"Opportunity #"}, { {"New", each Text.Combine([Product Code],", "), type number}})
in
    Sort

 

Please not your column Product Code needs to be formatted as text before applyting this code