topic Storing a value from csv file into variable in Talend Studio

Storing a value from csv file into variable

Anonymous — Tue, 28 May 2019 14:26:33 GMT

Hi,

I am trying to create a variable which stores the value that will be retrieved from a csv file.

Can someone please suggest an approach to achieve it?

Thanks in advance!

Alekhya.

Re: Storing a value from csv file into variable

Anonymous — Tue, 28 May 2019 14:40:33 GMT

Hi @alekhyak ,

We can able to save it in global variable or context variable, and it is depends on our requirement . But how is your actual csv file looks like and how many records does it have? and what are you going to do actually?

Re: Storing a value from csv file into variable

Anonymous — Tue, 28 May 2019 14:45:20 GMT

Hi,

My requirement is to store last column cell value(csv file may contain any number of rows but only limited columns) into a variable(global/context) and based on its value I need to run the further jobs.

Re: Storing a value from csv file into variable

Anonymous — Tue, 28 May 2019 14:52:58 GMT

Hi,

Does this mean are you going to run certain type of operation based on the value of last column. Please let us know do we have a fixed value in last column or it differs to each other. If it differs you may have multiple types of operations. Is it correct?

Re: Storing a value from csv file into variable

Anonymous — Tue, 28 May 2019 14:55:47 GMT

The value will be differing from time to time.

Re: Storing a value from csv file into variable

Anonymous — Tue, 28 May 2019 15:26:28 GMT

Please provide some sample records to understand and let us know what you are going to do with the last column values.