topic Re: Iterate CSV file to set context variables for each row in Talend Studio

Iterate CSV file to set context variables for each row

Anonymous — Fri, 24 Mar 2017 13:35:41 GMT

Hi,
I am trying to set context variable values from csv file columns, i.e. each column has value for a context variable, any comments on how to do that ?

Re: Iterate CSV file to set context variables for each row

vapukov — Fri, 24 Mar 2017 14:33:15 GMT

csv file must have only 2 columns one with name "key", second with name "value"
each row contain 1 key and 1 value

Re: Iterate CSV file to set context variables for each row

Anonymous — Fri, 24 Mar 2017 16:13:30 GMT

Thanks Vapukov for reply , Actually I need 4 columns to be substituted into 4 variable in one iteration, I tried that method using a properties files and tcontextLoad but it does not fulfill requirements

Re: Iterate CSV file to set context variables for each row

vapukov — Fri, 24 Mar 2017 21:13:10 GMT

sorry, can understand - what is You problem with normal tContextLoad? I load 100 variables at one iteration

all simple:
[list=*]

plain csv file - JUST 2 columns "key","value", as many rows as You need - 4-6-10-999

tFileInputDelimited -> connect to next by Main connection

tContextLoad

Re: Iterate CSV file to set context variables for each row

Anonymous — Thu, 30 Mar 2017 06:50:27 GMT

thanks vapukov , really appreciated your reply, I understand we can set all context variables using key value map into context load but my problem is i need to iterate this for 20 times and in each execution new values will be assigned to 4 variables. so i am trying to iterate csv file with 4 columns and 20 rows.

Re: Iterate CSV file to set context variables for each row

vapukov — Thu, 30 Mar 2017 09:31:00 GMT

think You mix context and normal csv file

why just not define csv file - as many columns as You need
than tFileInputCSV -> tFlowToIterate -> and use Your 1000 variables as You want

Context is context, and do not try to use it wrong

Re: Iterate CSV file to set context variables for each row

Anonymous — Fri, 31 Mar 2017 11:13:43 GMT

I have created separate file for each job and then used tFileList-->iterate-->tFileInputDelimited-->tContextLoad.
thanks for your time