Forum Discussion

chanpreet_90's avatar
chanpreet_90
Frequent Visitor
4 years ago

multiple rows into one row

  I have a data in this format and I want to combine the rows of Details into one row. please help me ...I am a beginner...I tried using Text.Combine but still getting error..   Thanks in adv...
Need Help
chanpreet_90's avatar
chanpreet_90
Frequent Visitor
4 years ago

Thank you for you response my friend..

I tried your solution but now im getting some 'error' in 'details', 'postdate' and 'valuedate'.

 

I guess the error in details column is coming because it has text and number both.

Please help

 

 

Regards

KT_Bsmart2gethe's avatar
KT_Bsmart2gethe
Impactful Individual
4 years ago

Hi chanpreet_90 ,

 

Define the data time before you apply GroupBy. Errors are general cause by a mix of data type. For those errors in the date columns, what are other values recorded under those column apart from date?

 

If you're apply the text.combine function. The column has to be in text format.

 

Regards

KT

  • chanpreet_90's avatar
    chanpreet_90
    Frequent Visitor
    4 years ago

    Hey...I am able to resolve the issue coming in Details column however still getting Error in date columns. Please check and help

     

    Regards

    • KT_Bsmart2gethe's avatar
      KT_Bsmart2gethe
      Impactful Individual
      4 years ago

      HI chanpreet_90 ,

       

      Are you able to share the code? The provided screenshot is insufficient to tell where the errors are from, apart from the errors that said you attempted to add the date. 

       

      Regards

      KT

      • chanpreet_90's avatar
        chanpreet_90
        Frequent Visitor
        4 years ago

        Helloo

         

        Here is the code : -

         

        let
        Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
        #"Changed Type" = Table.TransformColumnTypes(Source,{{"PostDate", type date}, {"ValueDate", type date}, {"Details", type text}, {"ChqNo", Int64.Type}, {"Debit", Int64.Type}, {"Credit", Int64.Type}, {"Balance", type number}}),
        #"Filled Down" = Table.FillDown(#"Changed Type",{"Balance"}),
        #"Grouped Rows" = Table.Group(#"Filled Down", {"Balance"}, {{"PostDate", each List.Sum([PostDate]), type nullable date}, {"ValueDate", each List.Sum([ValueDate]), type nullable date}, {"Details", each Text.Combine([Details], " - "), type nullable text}, {"ChqNo", each List.Sum([ChqNo]), type nullable number}, {"Debit", each List.Sum([Debit]), type nullable number}, {"Credit", each List.Sum([Credit]), type nullable number}})
        in
        #"Grouped Rows"