Need some help with Celigo Integrator.io if anyone has experience. I've created a dataflow from our Snowflake DW to NetSuite to import sales transactions as a Cash Sale. Got everything running fine, only problem I'm having is that because I'm querying data at the line-item level, I need to tell Celigo to group the import by Order ID so the cash sale has multiple lines on it and doesn't try to create multiple cash sales for the same transaction. I see that with Data Loader (CSV --> NetSuite) I have the ability to Group by Field Value, but I don't have that same option with the DataFlow out of Snowflake? Almost like I need to first export my data into CSV form, then upload the CSV into NetSuite just to have this ability? What am I missing here? (edited)

Celigo support is great, ask them

Just for reference this is being answered here: https://netsuiteprofessionals.slack.com/archives/C298P0BCK/p1654092231485959

yep, thanks @rico got it figured out