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 fo...
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

AlexisOlson's avatar
AlexisOlson
Super User
4 years ago

I don't see any screenshots.

  • 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