0

Duplicate several records in table

I would like to duplicate records in a table meeting the condition of having the same value in a field (order number). This value has to be change with a new one coming from the table that is executing the process.

Thanks

2replies Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
  • Try this:

     

    let old := 'old order number';
    let new := 'new order number';
    let t := (select 'Orders Table')['order number' = old];
    for i in t do
      let d := duplicate(i);
      d.('order number' := new)
    end

    DuplicateAndRename

    Like
    • Alvaro
    • Julsa Industrial SA
    • Alvaro
    • 1 yr ago
    • Reported - view

    Thanks!!! It is now working as you show

    Like
Like Follow
  • 1 yr agoLast active
  • 2Replies
  • 408Views