Clear Filter and Read Column data

[Lokeshwar]

Hi,

The file I am trying to read has pre-applied filter on a column. Upon reading the file through Input tool, it doesn't read the unfiltered data rather only the filtered data in that column.

Is there any possibility to read the unfiltered data as well in Alteryx (without un-filtering it manually in the file before reading in Alteryx workflow) ?

Thank you

Lokeshwar Sinha

[echuong1]

By default, Alteryx should ignore any filters in the file and import all of the data, so what you're seeing is unexpected. Are you able to upload a copy of your data?

[Emil_Kos]

Hi @Lokeshwar,

I don't think that should be the case.

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Does-the-input-data-tool-take-into-con...

Please make the copy of the file. Clear the filter and check if this will load full data set when loading whole data. 

I got a feeling it will still not load whole data set. 

[Lokeshwar]

Hi all,

Thank you for your responses. The input excel file contains a Pivot with Column Filter which i need to clear.
In such cases, Alteryx imports only the filtered data. Any help would be helpful to me.

Thanks

[Emil_Kos]

Hi @Lokeshwar,

You need to use the data source for the input of the pivot to make it work for you. Alteryx will not read what isn't show in the pivot. 

So point the Alteryx to the data source for the Excel pivot. You will not have any workaround for that.