I have an odd situation, although I'm sure it is common. The data file I'm pulling in (excel file) has a bunch of totals at the bottom(after some empty rows), so I want to read all the rows up to the first null value encountered in the ID field (first field).
any ideas?
Is there any way to set the record limit dynamically or something like that?
Solved! Go to Solution.
I would consider using a multirow formula:
IIF([Row-1:Keep]&&!ISNULL([Data]),'True','False')
This will make all rows up to (before) the first NULL() row TRUE and all subsequent rows FALSE.
note: Data is the field that you're checking....
Now you can filter on Keep = True.
Cheers,
Mark
I really like the idea behind this logic because it seems fairly simple, but for it's not working right for me yet.
It looks like Keep is getting forced to false. Is that because at the very beginning there is no Row-1 value? not sure how to get around that.
Cheers,
Mark
Rohanonline,
While it's a bit more involved of a solution (I'm trying to keep things simple), I got your solution to work, so thanks for the help
Rohan,
Fantastic!
Thank you so much. I'm a total noob when it comes to Alteryx but yes, this is a great solution.
Perhaps one day I will have a deep enough understanding to help others, but wow, this works great. Mark, thank you as well.
This is great. I'm looking at trying to do the same with columns. I want to read all the headers until the first null value is encountered in the field. I'm assuming I would need to use a multi field formula. How would the expression change? Thanks!