Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Duplicate Rows

Hello All,

 

I have the dataset as the following:

 

Part Number           Item description

026 48202 000        Catridge

026 35601 000         Oil

 

 

I need duplicate both the columns by four same rows . I have attached the screenshot of the final result.Any help will be appreciated.

 

Thank You

Iva

Need Help
  • MBreden's avatar
    MBreden
    4 years ago

    try this query

    let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMjAyUzCxMDIwUjAwMFDSUXJOLCnKTElPVYrVgUgam5oZGEIl/TNzlGJjAQ==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [#"Part Number" = _t, #" Item description" = _t]),
    GroupRows = Table.Group(Source, {"Part Number"}, {{"All", each _, type table}}),
    CustomRepeat = Table.AddColumn(GroupRows, "Repeat", each Table.Repeat([All],4)),
    RemoveOtherColumns = Table.SelectColumns(CustomRepeat,{"Repeat"}),
    Expand = Table.ExpandTableColumn(RemoveOtherColumns, "Repeat", {"Part Number", " Item description"}, {"Part Number", " Item description"})
in
    Expand

     /Melanie

4 Replies

  • AlexisOlson's avatar
    AlexisOlson
    Super User
    4 years ago

    You can define a new custom column as a list {1,2,3,4} or, equivalently, {1..4} and then expand that new column by clicking the expand button: 

     

    Add column:

     

    Expand column:

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

       

      • MBreden's avatar
        MBreden
        Helper I
        4 years ago

        try this query

        let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMjAyUzCxMDIwUjAwMFDSUXJOLCnKTElPVYrVgUgam5oZGEIl/TNzlGJjAQ==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [#"Part Number" = _t, #" Item description" = _t]),
    GroupRows = Table.Group(Source, {"Part Number"}, {{"All", each _, type table}}),
    CustomRepeat = Table.AddColumn(GroupRows, "Repeat", each Table.Repeat([All],4)),
    RemoveOtherColumns = Table.SelectColumns(CustomRepeat,{"Repeat"}),
    Expand = Table.ExpandTableColumn(RemoveOtherColumns, "Repeat", {"Part Number", " Item description"}, {"Part Number", " Item description"})
in
    Expand

         /Melanie