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

2 replies

null
    • Choices_Software_Dean
    • 4 yrs ago
    • Reported - view

    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

    • Julsa Industrial SA
    • Alvaro
    • 4 yrs ago
    • Reported - view

    Thanks!!! It is now working as you show

Login to reply

Content aside

Categories

View all topics
  • 4 yrs agoLast active
  • 2Replies
  • 441Views