topic Re: Filter data from an ODBC database by string slicing in App Development

Filter data from an ODBC database by string slicing

Denzyl — Fri, 02 Sep 2022 09:04:08 GMT

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

Re: Filter data from an ODBC database by string slicing

SunilChauhan — Fri, 02 Sep 2022 09:19:15 GMT

use Below

Wildmatch( FIeldName,'*AP')

If(WildMatch(FIeldName,'*AP'),FIeldName) as Test.

See the attached Example where we want to filter Date where we have 22 in END

Re: Filter data from an ODBC database by string slicing

Denzyl — Fri, 02 Sep 2022 09:28:06 GMT

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.

Re: Filter data from an ODBC database by string slicing

Aurelien_Martinez — Fri, 02 Sep 2022 12:30:21 GMT

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-connectors.htm

Perhaps with : code NOT LIKE '%AP'

Example with my data on snowflake

Re: Filter data from an ODBC database by string slicing

Timario — Mon, 05 Sep 2022 04:15:36 GMT

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.