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!
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?
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.
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?
Please provide some sample records to understand and let us know what you are going to do with the last column values.
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Part 2 of a series on Context Variables
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema