Forum Discussion
bojanvelevski
4 years agoValued Contributor
I think the Filter snap will do the job. For your first use case, If you want to check if some of the fields has a specific value, you’ll need something similar to this:
$Record == 'Required Value'
If your requirement is to check if you have any records at all, you can either group the records in an array, and count its length, or use an Aggregate snap after the CSV Parser/SQL reading, select the COUNT Function and add a result field , than again use the Filter snap with the following expression:
$ResultField > 0
Hope this helps,
Regards,
Bojan