Forum Discussion

jlauyfc's avatar
jlauyfc
Frequent Visitor
2 years ago
Solved

Table grouping by passing columns name from anther table

Hi guys   I'm trying to group my product export csv file by a few keys and an aggregatedColumns "Variant SKU". I got errors on the aggregatedColumns column that added. I spent a few hours searching...
Need Help
  • ronrsnfld's avatar
    ronrsnfld
    2 years ago

    I can't help you with Error #1 since, as you wrote, the sample does not reproduce it.

     

    For Error #2,  try this for your #"Grouped Rows" step

        #"Grouped Rows" = Table.Group(#"Added Custom", Table.Column(#"Product List Header Group Key", "Key"), {
        {"Variant SKUs", 
    each Text.Combine(Table.Column(_, #"Product List Header Group Aggregate"[Aggregate Column]{0}),", ")}})

     

    Results

     

     

     

ronrsnfld's avatar
ronrsnfld
Icon for Super User rankSuper User
2 years ago

I can't help you with Error #1 since, as you wrote, the sample does not reproduce it.

 

For Error #2,  try this for your #"Grouped Rows" step

    #"Grouped Rows" = Table.Group(#"Added Custom", Table.Column(#"Product List Header Group Key", "Key"), {
        {"Variant SKUs", 
    each Text.Combine(Table.Column(_, #"Product List Header Group Aggregate"[Aggregate Column]{0}),", ")}})

 

Results

 

 

 

jlauyfc's avatar
jlauyfc
Frequent Visitor
2 years ago

It is working now. Luckily error 1 disappeared🤣. Thanks for your help!