topic Re: Loading data that contains certain text in QlikView

Loading data that contains certain text

PipCymruUK — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I am a total newbie, so please be gentle with me.

I have the following script to load data from a database.

SQL SELECT

"scheduled_date",

"scheduled_date_year",

"work_item_type_name"

FROM "ConMonLive_Reporting".dbo."t_work_item_summary"

How do I only load data where "work_item_type_name" contains the word "Time" please?

I have tried Wildmatch bet get an error.

Many thanks

Re: Loading data that contains certain text

Taoufiq_Zarra — Tue, 10 Mar 2020 11:27:58 GMT

WildMatch() is a QlikView function, not a SQL function

so you can use for example :

load scheduled_date, scheduled_date_year, work_item_type_name Where WildMatch(Upper(work_item_type_name),'*TIME*'); SQL SELECT "scheduled_date", "scheduled_date_year", "work_item_type_name" FROM "ConMonLive_Reporting".dbo."t_work_item_summary"

Re: Loading data that contains certain text

PipCymruUK — Tue, 10 Mar 2020 11:45:28 GMT

Hi,

That has worked but has increased by reload time significantly, are you aware if their is an equivalent SQL function that does the same job?

Thanks

Re: Loading data that contains certain text

Taoufiq_Zarra — Tue, 10 Mar 2020 11:50:35 GMT

I don't know if this will help you, but you can usein SQL

WHERE "work_item_type_name" LIKE '%Time%'

Re: Loading data that contains certain text

PipCymruUK — Tue, 10 Mar 2020 11:55:10 GMT

That has worked a treat, thank you so much.