Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, I need to use the data manager to filter data being brought into Qlik.
I'm trying to remove records that end in "Test"
I've tried the following
right([Full Name],4)<>'Test'
It works as a new column, but not as a filter in the loading page for files.
I am unable to use data load editor.
Thank you!
Hi,
You cannot use expression nor wildcard in the filter option of the Data Manager. You'll need to use the script for your usecase.
Regards