Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
When loading a table from an ODBC, I would like to filter the dataset based on a column that ends with a certain value.
I have a column [code] that is made up of various text of different length.
I am trying to filter all the rows that does not have a [code] ending with AP.
I tried the following code but it does not work
Hi,
In the documentation we have all operator you can use : https://help.qlik.com/en-US/sense/August2022/Subsystems/Hub/Content/Sense_Hub/LoadData/Filter-data-c...
Perhaps with : code NOT LIKE '%AP'
Example with my data on snowflake
use Below
Wildmatch( FIeldName,'*AP')
or
If(WildMatch(FIeldName,'*AP'),FIeldName) as Test.
See the attached Example where we want to filter Date where we have 22 in END
Hi, I've tried to use Wildmatch, and it did not work as well.
Just to be clear I am trying to use the Filter data option in the "Edit Selections" page when loading data from an ODBC connection not trying to write the loading script, using the load editior.
Hi,
In the documentation we have all operator you can use : https://help.qlik.com/en-US/sense/August2022/Subsystems/Hub/Content/Sense_Hub/LoadData/Filter-data-c...
Perhaps with : code NOT LIKE '%AP'
Example with my data on snowflake
Hi, in filter try use keyword like
right(code,2) like 'AP%'. It means that 2first symbols of code start with AP.
right(code,2) like '%AP%'. It means that 2first symbols of code has AP.
right(code,2) like 'AP%'. It means that 2first symbols of code end AP.