Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Good afternoon.
I have been using the below For loop without any problem, until today.
I have a new Site with the code BH001. When I include BH001 vCompaniesToInclude variable, get the error "Field BH001 not found".
Please can you tell me how to include the Site which is not a numeric number.
SET vCompaniesToInclude = '2373','2729','3056','3252','BH001';
For Each vCompany in $(vCompaniesToInclude)
t1:
LOAD
Site, .....
FROM [$(vRAW_QVDFolder)\Extract.csv]
(txt, utf8, embedded labels, delimiter is ',', msq)
Where Site = $(vCompany);
next vCompany
Thank you very much.
Where Site = '$(vCompany)';
Where Site = '$(vCompany)';
Thanks a lot