Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
I don't know if this will help you, but you can usein SQL
WHERE "work_item_type_name" LIKE '%Time%'
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"
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
I don't know if this will help you, but you can usein SQL
WHERE "work_item_type_name" LIKE '%Time%'
That has worked a treat, thank you so much.