This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
FAQ
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Discard empty rows while writing an excel file

ankita1212
New Contributor

‎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.

image

Please advise how can these empty rows be ignored

0 Kudos
Reply
2 REPLIES 2

igormicev
Contributor

‎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

Reply

ankita1212
New Contributor
In response to igormicev

‎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.

Reply