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.
Solved! Go to Solution.
It's work! Thank you so much!!!