I need a hint when loading a file with Data Exchange, we need to skip the line when an attribute column is null.
Tried many options like using SQL in the Target Expression, conditional in Source Expression, but no success.
My file load has 4 attribute columns and I use them to later map members with SQL expressions. But I would need to skip lines where one of these columns has no values, and that's the tricky part. This is a delimited file load.
Any suggestions?
Thanks!