where function

[eswarchandan]

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

[prma7799]

What is error?

[eswarchandan · Accepted solution]

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