Does the input data tool take into consideration the filters within excel file? I'm trying to import an excel which has data filtered within the file already. Unfortunately Alteryx doesn't know that the excel is filtered. It loads all the rows.
Solved! Go to Solution.
Hi @monish_chandra Alteryx would ignore those filter and as described import all the data. You would need to use the filter tools to replicate the filters in excel within Alteryx designer.
As @JosephSerpis mentions, Alteryx will ignore all filters and import all of the data.
Some workarounds: Recreate the Filters in Alteryx using the Filter tool. So easy, and so fast! Plus, with all of the data, you have a ton more flexibility in your analysis!!
In Excel, copy the filtered data and paste onto a new sheet. Either create a named range for that data, or import the new sheet. Then you'll only get that data that you want.
Let me know if that helps.
Cheers!
Esther