Pipelines CSV Handler
I'm receiving a .CSV file via the Pipelines 'CSV Handler'. In the second step I'm using 'Iterate over CSV Records'.
What I am trying to do is use the csv which looks like this:
I want to create a single record in a table called 'Orders' for each order, and then child records in a table called 'Warehouse Requests' for each SKU under an 'Order', which will be used to generate a warehouse pick-list.
I'm getting stumped by the first part of this. The pipeline runs and seems to loop over the records but only creates blank records for each row.
I haven't even started on the next part which is to generate all of the child records for each SKU.
Anyone have any ideas on what I might be doing wrong or if there's a different approach I should consider?
------------------------------
Jeff Peterson
------------------------------