topic Re: [resolved] Excel file generation dynamically,different name for each excel in Talend Studio

[resolved] Excel file generation dynamically,different name for each excel

Anonymous — Sat, 16 Nov 2024 11:35:03 GMT

Hi All,
After a long time i am posting something.
I hope you all will reply to my query like previously.
I am processing 10 csv files which are in one folder and want to load the data in excel file.
But excel file should generate dynamically.
Here what does it mean dynamically????
It means for every CSV file,an excel should get generate with the same name of CSV.
e.g.
Cust1.csv then excel file should generate with name of Cust1.xls
Cust2.csv then excel file should generate with name of Cust2.xls
.
.
.
.
.
.
.
Cust10.csv then excel file should generate with name of Cust10.xls
I am waiting for the reply...

Re: [resolved] Excel file generation dynamically,different name for each excel

Anonymous — Wed, 16 Jul 2014 09:03:27 GMT

Hi Kunal,
You will have to perform the string handling operation like LEFT and Concatenation...
In your output file name, use LEFT and extract the file name from CSV file name or currentFileName variable and concatenate with ".xls"
I hope you got an idea.
Vaibhav

Re: [resolved] Excel file generation dynamically,different name for each excel

Anonymous — Wed, 16 Jul 2014 09:44:10 GMT

take CSV name and assign it to context or global variable and then do following action in output excel components file name field.

context.FilePath+context.FileName.toUpperCase().replace(".CSV", ".XLS")

hope this will work.

Re: [resolved] Excel file generation dynamically,different name for each excel

Anonymous — Wed, 16 Jul 2014 13:20:50 GMT

Hey hi Umesh,
Sorry but its not working...I have tried.
I want to generate excel file dynamically with names as source files.

Re: [resolved] Excel file generation dynamically,different name for each excel

willm1 — Wed, 16 Jul 2014 14:01:29 GMT

Hi Kunal -
This is not exactly what you're asking for, but it will give you ideas on how to solve your particular problem:
http://www.talendforge.org/forum/viewtopic.php?pid=131115#p131115
Another one is - http://www.talendforge.org/forum/viewtopic.php?pid=130539#p130539
For dynamic schemas, see https://help.talend.com/pages/viewpage.action?pageId=5671283
umeshrakhe has already shown how to assign the file name to a variable and change its extension from csv to xls.
Let us know if you're not able to make progress...

Re: [resolved] Excel file generation dynamically,different name for each excel

Anonymous — Thu, 17 Jul 2014 04:38:03 GMT

Hi kunalrane,
What's your issue for context value?
Have you tried global variable

((String)globalMap.get("tFileList_1_CURRENT_FILEPATH")).replace("txt", "xls")

Best regards
Sabrina