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

     

     

     

foodd's avatar
foodd
Icon for Community Champion rankCommunity Champion
2 years ago

That is easy!  Share any related source files and your work-in-progress Excel (.xlsx) file in the same manner as you would if it were a Power BI Desktop File. By doing this, it will provide community members assisting you with a clearer understanding of your issue within the correct context. Thank you!

 

If your requirement is solved, please make THIS ANSWER a SOLUTION ✔️ and help other users find the solution quickly. Please hit the LIKE 👍 button if this comment helps you.  Proud to be a Super User!

jlauyfc's avatar
jlauyfc
Frequent Visitor
2 years ago

I've uploaded the excel file, source csv and the expected result sample files.

  • 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