Help

Create number of records in 1 table based on Qty Field in another table

Topic Labels: Scripting extentions
1055 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Harry_McDonald
6 - Interface Innovator
6 - Interface Innovator

Hey there,

I’m hoping someone will be able to help (my scripting ability is limited) - I want to be able to create a specific number of records in Table 2 based on the Qty field in Table 1.

I have a script which creates a singular record in Table 2 from the data in Table 1 but does not consider the QTY field and creates the X number of rows.

Would anyone be willing to help please?

Thanks in advance

2 Replies 2
Harry_McDonald
6 - Interface Innovator
6 - Interface Innovator

Screen Shot 2022-09-05 at 11.43.33 am

Harry_McDonald
6 - Interface Innovator
6 - Interface Innovator

Solved by changing ‘originalLineItem.Length’ to ‘Quantity’ input variable.