For loop with numbers and text

johngouws — Fri, 13 Jan 2023 11:01:42 GMT

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.

Re: For loop with numbers and text

MarcoWedel — Fri, 13 Jan 2023 11:07:56 GMT

Where Site = '$(vCompany)';

johngouws — Fri, 13 Jan 2023 12:25:56 GMT

Thanks a lot