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

Announcements
Learn how to migrate to Qlik Cloud Analytics™: On-Demand Briefing!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Type List Variables (LOV) of Context

How do I iterate a context variable of type List of Values (LOV)?
Labels (2)
1 Reply
Anonymous
Not applicable
Author

Hi
In fact, the list of values are stored as a string in context properties file, the job read its value as a string during the job execution. The solution is to define the data type as a string, and set the value like:
v1,v2,v3,...
In the job, use tNormalize to normalize the value to multiple values, and then iterate each value. For exmaple:
tFixedFlowInput--main--tNormalize--main--tFlowToIterate---do other process
on tFixedFlowInput, generate one data with context variable, define one column called 'mydata' on the schema, string type.
column:value
mydata:context.yourVariableName
on tNormalize, select 'mydata' to normalize with Item separator ",".