Delete empty rows from excel output

[Ardra]

Hi,

I have a workflow that writes result to a formatted excel sheet. Now there is a requirement to delete empty rows from the output. How can I achieve that?

[Felipe_Ribeir0]

Hi @Ardra 

If you want to remove null/empty rows from your dataset before writting it to excel, one way of doing this is using the filter tool with this formula. Replace the ColumnA of the formula by the column of your dataset that you want to use as reference to remove nulls/empty rows and write to excel after it and it will work.

!IsNull([ColumnA]) AND !IsEmpty([ColumnA])

[damalraj22]

Hi, 

You can use the Data Cleansing tool to do this pretty easily. Just select remove null rows and you should be set. 

[DavidSkaife]

Hi @Ardra 

Note that IsEmpty performs the same check as IsNull, alongside checking for empty fields, so you could use just IsEmpty.

[PanPP]

Hi @Ardra 

You can utilize the following expressions.

IsNull([ColumnName])  --> Will remove null values

IsEmpty([ColumnName]) --> will remove empty values

Hope this helps.