Robust Transform - one resource row to multi rows in a table

[YonkH]

Hello

There is a row in staging table which contain a comma separated string, for example: "ip1, ip2, ip3", need insert to target IP Address table after split string by comma, will insert 3 rows. I think it need split the string to an array field first, then configure entity mapping, I have a try but inset failed, there is no detail description about this in SNOW docs, do you know whether Robust Transform support it and how to set?

Thanks

[karsrao]

Just wanted to check if you got this working, did you go with entity operation or convert to array. I am thinking of inserting the records to intermediate temp entity and map that to the target table ( where I want each element of array to be created as separate record]

[YonkH]

No, as Kevin mentioned above, it's overkill because existing other entity fields one to one mapping in Robust transform. I think the replaced option one is to split the data in source table if possible, another is as Kevin's suggestion, to create a mapping to that 'field', and on the entity create a scripted entity operation that takes that field as an input and creates the records.