Forum Discussion

ankita1212's avatar
ankita1212
New Contributor
5 years ago

Discard empty rows while writing an excel file

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 is...
oracle
pipeline
salesforce
igormicev's avatar
igormicev
Contributor
5 years ago
Copy LinkReport

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

ankita1212's avatar
ankita1212
New Contributor
5 years ago
Copy LinkReport

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.

Related Content