Clear Filter and Read Column data

Question

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

Emil_Kos · Answer

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.

Lokeshwar · Answer

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 · Answer

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-consideration-the-filters/m-p/454383/highlight/true#M88122

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.