Hi, I've a set of data in excel file with 5 records.
From excel point of view, there are 5 records (when we open excel file) but Alteryx gives me 14 records. I was able to get 5 records by adding a filter and using isempty() function for all the fields. Since the fields were less, I was able to manage but how do we handle this if we have more than 50 or 60 records.
Attached is the workflow with data for your reference.
Solved! Go to Solution.
There are several tools available on the gallery that can handle this....I have this one installed:
This worked and solved my issue but I've a question on this, what if I've space in my excel file instead of null or a combination of Null and spaces in multiple columns ? How can we handle this