Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
johngouws
Partner - Specialist
Partner - Specialist

For loop with numbers and text

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. 

Labels (1)
1 Solution

Accepted Solutions
MarcoWedel

Where Site = '$(vCompany)';

View solution in original post

2 Replies
MarcoWedel

Where Site = '$(vCompany)';

johngouws
Partner - Specialist
Partner - Specialist
Author

Thanks a lot