Change filename

One Star

Change filename

Hi,

How can I change the name of an excel file with the content of the first field of the first line of this excel file ?

Is it possible ?

Thank you !

Quartz - France - Paris
One Star

Re: Change filename

for renaming a file you can use tFileCopy and set the checkboxes for rename and delete source. in the textfield for the filename you can use a variable you have filled before with the content of your cell from the excelfile.

regards,
blackfox
One Star

Re: Change filename

I have see the tFileCopy, but I don't know how creating the variable with the excel field ...
One Star

Re: Change filename

Haven't tried but you may use a tFileInputExcel, define a schema, limit to 1 row in the basic settings.
Use a tSetGlobalVar to put the desired column in the global vars. Access the first column like row1.firstColumnNameInSchema

2019 GARNER 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

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

6 Ways to Start Utilizing Machine Learning with Amazon We Services and Talend

Look at6 ways to start utilizing Machine Learning with Amazon We Services and Talend

Blog

Why Companies Move to the Cloud: 7 Success Stories

Learn how and why companies are moving to the Cloud

Read Now

Agile Data lakes & Analytics

Accelerate your data lake projects with an agile approach

Watch