Forum Discussion

Ortignano's avatar
Ortignano
Helper II
5 years ago
Solved

Repeat row in a table

Hi, I have a table with product number, qty and ID and another table with a number n (time to repeat) and m (start number) I would modify first table repeating  For example    Product number qty...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    somethink like this?

     

    let
    Origine = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WclTSUTJSitWJVnICskzALGcgy1gpNhYA", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [prod = _t, qty = _t]),
    m=7,
    n=4,
    #"Aggiunta colonna personalizzata" = Table.AddColumn(Origine, "id", each List.Range({1..100},m-1,n)),
    #"Tabella id espansa" = Table.ExpandListColumn(#"Aggiunta colonna personalizzata", "id")
in
    #"Tabella id espansa"
Anonymous's avatar
Anonymous
Not applicable
5 years ago

somethink like this?

 

let
    Origine = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WclTSUTJSitWJVnICskzALGcgy1gpNhYA", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [prod = _t, qty = _t]),
    m=7,
    n=4,
    #"Aggiunta colonna personalizzata" = Table.AddColumn(Origine, "id", each List.Range({1..100},m-1,n)),
    #"Tabella id espansa" = Table.ExpandListColumn(#"Aggiunta colonna personalizzata", "id")
in
    #"Tabella id espansa"
  • Ortignano's avatar
    Ortignano
    Helper II
    5 years ago

    Thank you is what I need