stop reading or discard any records read after the first null value encountered in field

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?

Input

Accepted answers

rohanonline

You may try the attached flow. I have used a text input for sample data - you may need to replace it with the excel file.

Dynamic Select.JPG

Select records dynamically.yxmd

rohanonline

@PabloDanielovich I think your workflow had the issue of the initial value. Check the attached.

DiscardDataAfterFirstNullRow.yxmd

All comments

MarqueeCrew

I would consider using a multirow formula:

Create New Field = [Keep]
- Type = Bool
- # of rows = 1
- Values for rows that don't exist = 0 or Empty

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

rohanonline

You may try the attached flow. I have used a text input for sample data - you may need to replace it with the excel file.

Dynamic Select.JPG

Select records dynamically.yxmd

PabloDanielovich

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.

PabloDanielovich

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

sujana117

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!

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15878

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703