Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
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