Remove Empty Rows

[Shaaz]

 Hi All,

I've 2 excel file's with 15 columns and 100 rows with same data structure and I'm using * to fetch both the files.

Out of 100 rows, 60 rows has data in it whereas remaining 40 rows are completely empty.

I can exclude the empty rows using data cleanse tool.

But I need to fetch FileName from input tool and because of which I'm unable to use data Cleanse tool.

How do I achieve this ?

1. Remove empty rows

2. I should have the FileName in the output.

[dsandmann · Accepted solution]

This should have the desired effect - I had to do this myself on a recent project.

 

[MayaPhan1992]

It's work! Thank you so much!!!