Loading data that contains certain text

[PipCymruUK]

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

[Taoufiq_Zarra]

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"

[PipCymruUK]

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

[Taoufiq_Zarra · Accepted solution]

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

WHERE "work_item_type_name" LIKE '%Time%'

[PipCymruUK]

That has worked a treat, thank you so much.