Forum Discussion

PietroFarias's avatar
PietroFarias
Resolver II
7 years ago
Solved

Duplicate Rows of a Query (Power Query)

Would anyone know how I can duplicate the rows of a query based on a value in a column? Here's an example:     ID Installments 1357 5 1606 3 1126 2 To: ID Installments...
  • Ashish_Mathur's avatar
    7 years ago

    Hi,

     

    Try this M code

     

    let
        Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMjQ2NVfSUTJVitUBcswMzIAcYwjH0AjEMVKKjQUA", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type text) meta [Serialized.Text = true]) in type table [ID = _t, Installments = _t]),
        #"Changed Type" = Table.TransformColumnTypes(Source,{{"ID", Int64.Type}, {"Installments", Int64.Type}}),
        #"Added Custom" = Table.AddColumn(#"Changed Type", "Custom", each {Number.From(1)..Number.From([Installments])}),
        #"Expanded Custom" = Table.ExpandListColumn(#"Added Custom", "Custom"),
        #"Removed Columns" = Table.RemoveColumns(#"Expanded Custom",{"Installments"}),
        #"Renamed Columns" = Table.RenameColumns(#"Removed Columns",{{"Custom", "Instalments"}}),
        #"Changed Type1" = Table.TransformColumnTypes(#"Renamed Columns",{{"Instalments", Int64.Type}})
    in
        #"Changed Type1"

     

    Here is the result