Storing a value from csv file into variable

Five Stars

Storing a value from csv file into variable

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.

Six Stars

Re: Storing a value from csv file into variable

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?

Five Stars

Re: Storing a value from csv file into variable

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.

Six Stars

Re: Storing a value from csv file into variable

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?

Five Stars

Re: Storing a value from csv file into variable

The value will be differing from time to time.
Six Stars

Re: Storing a value from csv file into variable

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

2019 GARTNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

Best Practices for Using Context Variables with Talend – Part 2

Part 2 of a series on Context Variables

Blog

Best Practices for Using Context Variables with Talend – Part 1

Learn how to do cool things with Context Variables

Blog

Migrate Data from one Database to another with one Job using the Dynamic Schema

Find out how to migrate from one database to another using the Dynamic schema

Blog