topic Re: where function in QlikView

where function

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

Hi,

I am loading the below script with sample where function ......i need the correct solution for it .....I am loading data from Excel sheet

LOAD LensCatLevel2Code, %Photo***** As %Trs****, %Photo****** As %Trs******
FROM [$(BASE_RES_Path)$(vParmMarketing)] (ooxml, embedded labels, table is PT_DESIGN_GRP)
WHERE LEFT(lenscatlevel2Code,2) = '2-';

Kind Regards,

Eswar

Re: where function

prma7799 — Fri, 26 Jul 2019 04:59:47 GMT

What is error?

Re: where function

eswarchandan — Fri, 26 Jul 2019 05:12:57 GMT

I got the solutions I did simple mistake ...... Thanks for your reply @prma7799