Type List Variables (LOV) of Context

One Star

Type List Variables (LOV) of Context

How do I iterate a context variable of type List of Values (LOV)?
Community Manager

Re: Type List Variables (LOV) of Context

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 ",".
----------------------------------------------------------
Talend | Data Agility for Modern Business