Change filename

Highlighted
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
Highlighted
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
Highlighted
One Star

Re: Change filename

I have see the tFileCopy, but I don't know how creating the variable with the excel field ...
Highlighted
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 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

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

Downloads and Trials

Test drive Talend's enterprise products.

Downloads