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

You need to make those files accessible.

jlauyfc's avatar
jlauyfc
Frequent Visitor
2 years ago

fixed. Thanks.

  • 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!