Filter icon greyed out in Data Manager

[stijnval]

Hi experts,

When loading local files in the Data Manager, we can see a filter icon, however it is constantly greyed out. Anybody knows how to get this button enabled?

Thanks in advance!

Stijn

[bwisealiahmad · Accepted solution]

Hi,

You are using Excel file and you can't do that kind of filtering there (at least not yet).

If you can get the same data from a database you can do it there if you still want to use the Data Manger, otherwise I would add the Excel file through the Data Load Editor and use a "WHERE" clause on the load.

See picture from example where I've fetched data from a database and the icon is active:

[stijnval]

Thanks Ali!