AnsweredAssumed Answered

Importing, Moving Multiple Records Between Tables Script

Question asked by kat012002 on Feb 13, 2015
Latest reply on Feb 16, 2015 by philmodjunk


Importing, Moving Multiple Records Between Tables Script


Hello All,

I have a file with shipment information that I need to import into separate tables, a shipment name/id table and a shipment line items table. The problem is it is formatted in a way that the shipment name/id is located in column 2, row 1. The shipment line item information starts at row 9 and but the number of subsequent lines vary with each shipment.

I’m not sure how to go about writing a script to create a new shipment in the shipment table using the value from column 2/row 1, then create child records in the shipment line items table with the values starting at row 9.

I have written a couple executeSQL calculations that gather the shipment name and line item information I need but I can’t figure out how to use the data from the executeSQL calc to create the shipment line items records.

Is there a better way to do this?

Any help and/or suggestion would be very much appreciated!