10-15-2020 12:52 AM
I am trying to write an excel after comparing a database with salesforce data, I want to ignore the null rows after comparison is done in a mapper post Join. The data I am getting is perfect, only issue is with the way excel looks like.
Please advise how can these empty rows be ignored
10-15-2020 01:43 AM
Hi @ankita1212,
Simply, use the Filter snap. For example $column_name != null will filter the nulls for the column. You can combine multiple columns as well.
/Igor
10-15-2020 02:07 PM
Hi Igor,
Thanks you for the reply, the mistake I made was I had not included $column_name != ‘’ along with $column_name != null. When I did it worked like a charm.