Discussion Board for collaboration on QlikView Scripting.
I am using the below script and the "LOB_ID" Like '7*' piece is returning no results when I know there should be. Can someone please let me know what I may be doing wrong?
"PCP_ID" AS mms_PCP_ID,
"VEND_ID" AS mms_VEND_ID,
"LOB_ID" AS mms_LOB_ID,
"MEM_ID" AS mms_MEM_ID
WHERE "EFF_DT" >= 42979 AND "EFF_DT" <= 43008 AND "LOB_ID" LIKE '7*';
Go to Solution.
Try with % for WildCard
WHERE "EFF_DT" >= 42979 AND "EFF_DT" <= 43008 AND "LOB_ID" LIKE '7%';
Thanks, Sunny! I had been reading everywhere that SQL syntax isn't supported in the script so I didn't even think to try that. It is working perfectly now.
Actually anything you have after SQL SELECT needs to have SQL Syntax because if you don't (and use QlikView syntax) it won't work. Anything after SQL SELECT is sent to the database for querying and needs the SQL syntax.