Forum Discussion

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...

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}})

Anonymous

Not applicable

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}})