Transform Map - Ignore Row if any fields are empty

[Harry Campbell2]

Hello All,

When transforming an import set table. Is it possible to ignore any rows that have an empty field?

We want to ensure that all rows to be imported have complete information. Is there a transform script I can utilize to achieve this?

I have tried just using 'Enforce Mandatory Fields' but this doesn't work, the data is still imported with empty fields.

Many Thanks

Harry

[peterh_smith]

In the onStart script, use GlideRecord to query the import set for any record that has a blank field.   Abort if you find a record.   That way, you don't have to undo anything that happened before you reach the blank record.