I'm trying out integrator.io (Celigo) data loader for a CSV import that's not supported natively in NetSuite (Cash Refund). I have multiple rows per a transaction for each line item, however I can't figure out how to group them in integrator.io and it is creating a separate transaction for each line. Any ideas?

You need to first make sure multiple rows are together in the sample file. When you start creating data loader, check the checkbox "multiple rows per record" and then select the column name having multiple rows. This would make sure that the data is grouped before importing into NS.

Thanks @Ritika Chaudhary, that's exactly what I was looking for

there should be a dropdown option for externalid, shouldn't need to use a formula i think

Yep. When you do the field mapping, it should show up there as an available field.

External id would show up as it's NS default field for the customer record type. I see you selected a different "Search Record Type" in the field mapping, make sure it's customer record type. Let me know if this works!

@al3xiconWhen I choose "External ID" it was picking up some other custom record, so that's why I went with a formula. But I had another look now and the actual external id is there, called

External Id

Strange, maybe the list was cached from a previous selection?

It was probably there the whole time and I just missed it

Great! good to know it worked!