Hi all, I’m looking for some help with getting data from a CSV file fed into multiple tables in my app.
The data I’m working with is order data, where the rows represent one line item in the order and reference the order they’re from.
Essentially I want to split this data into two separate tables - orders and products. I’ve tried to trigger backend workflow when there is a change in the database, but it’s not parsing each line one after the other, which means I’m getting duplicate orders in the order table.
Does anyone have any suggestions for how to go about parsing new db rows individually when uploaded by CSV?