How to capture all errors in a row

[hima_shar]

Hello All,

I have a CSV file which I have to load to a Oracle target. I have serval checks like number fields should be a number, Date should be a valid date, Length check for some of the character fields etc..

I need to capture all the errors in a table for a particular row.. Do I need to use filter tool multiple tool and then union?

Or is there any better way of achieving this?

Regards

Himanshu

[LordNeilLord · Accepted solution]

Hi @hima_shar,

I would look to utiise the Mutli-Field tool here, you can define a condition for each datatype that you are validating...for example using isNumber() to validate the numeric fields. This will then give you a boolean response for that field.

Once you have defined all of your conditions, you can transpose the results and then filter on any 0 (false) which will show you where there are errors.

I have attached an example

[hima_shar]

Great. That's exactly I was looking for.

Thank you so much for quick response.