Determine if flat file field value is NULL.
We recently purchased Scribe and are having difficulty determining if a field value in a flat file is NULL or not. The Scribe Online map is set up to query the flat file, then enter a For Each loop, and then have an IF block.
In the IF block I have entered the below conditional logic:
SfSyncReport.ERCode is not equal to NULL
What I'm hoping to have happen here is only records from the flat file that have an ERCode not equal to NULL are entered into the IF block; all other records would go down to the ELSE block.
For some reason when using this logic all records are going into the IF block, regardless of the ERCode value in the flat file.
I have attached the flat file for reference.
Any assistance is solving this issue is much appreciated.