Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Does the input data tool take into consideration the filters within excel file?

monish_chandra
8 - Asteroid

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. 

2 REPLIES 2
JosephSerpis
17 - Castor
17 - Castor

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.

estherb47
15 - Aurora
15 - Aurora

Hi @monish_chandra 

 

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

Labels