Filter data from an ODBC database by string slicing

[Denzyl]

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

[SunilChauhan]

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 

[Denzyl]

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.

[Aurelien_Martinez · Accepted solution]

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

[Timario]

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.