Impose sample restrictions in Alteryx designer

[deriant12]

How can I perform/input these restrictions to get results from a large excel file?  

2016 >= fiscal year >=2011

and

Positive pretax income (pi>0)

[Qiu · Accepted solution]

@deriant12 
I dont think we can restrict that for input.
We can pull in all the data then use a filter.

[deriant12]

Thanks Qiu!  So I merged all the files and tried to add the filter but I get this:

[Qiu · Accepted solution]

@deriant12 
Based on the error, message, I think you mistakenly select the "Import only the list of sheet names".
You should select the correct Sheet.

[deriant12]

Your solution worked but now the formula errors.  So I merged the 3 excel files into one.  The one file has three tabs (list of sheets).  Can I pull the info I need using the one sheet and the list of sheets names simultaneously?