This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
my data ended at Record # 1084573, but it seems that my output inserted additional blank rows. are there any tools that allows me to remove the blank rows? from row # 1084574 onwards?
Go to Solution.
Go to Solution.
Hi, as far as I know Alteryx does not have a build-in tool to remove empty rows. But the required results could be achieved by a combination of tools:
I would bring in the sample tool at the start of the worflow to filter out anything at the start.
It could help with performance.
1. You can use sample tool to restrict the no. of rows but if more rows comes then there will be loss of data..so prevent this data loss you can simply filter at one of you key field for not null.
2. And if you still want to restrict the no. of rows you can put "record limit" in input tool configuration itself.
You could use the Filter tool to find records with IsNull([Field]) -- or IsEmpty([Field])...
I tried your approach using a column. however there is a possibility that the column selected for the isnull() or isempty() filter itself is not available in the data reaching there.
Is there any other approach we can think of ?
It is quite interesting that Alteryx does not provide a simple tool to remove empty rows. My best guess is we can use R or Python to achieve this but not sure about the performance.
I just had the same issue.
-I was able to complete by using the Filter Function.
-Use the Basic Filter and select !IsEmpty([county])
-I was trying to remove rows where the count was Empty.