topic How to Dynamically get an Excel file name in Talend Studio

How to Dynamically get an Excel file name

Anonymous — Sat, 16 Nov 2024 03:43:51 GMT

Hi,

I am using tFileInputExcel Component and how to get the input file on dynamically,

I use ((String)globalMap.get("tFileInputExcel_1_FILENAME")) in a field in tmap component but it doesnt work.
Any help?

Re: How to Dynamically get an Excel file name

Anonymous — Wed, 25 Dec 2019 08:51:01 GMT

is the file name a variable or fixed value on tFileInputExcel? You can use a context variable as file name, for example:
"D:/file/"+context.filename
And then, you can get the file name using context.filename on any other components.

BTW, please insert your images into post body instead of attaching it.

Regards
Shong

Re: How to Dynamically get an Excel file name

Anonymous — Wed, 25 Dec 2019 09:51:52 GMT

Hi,
Could you please let me know where should I need to add this context.filename and my input file name is not fixed, it's a dynamic name.

Re: How to Dynamically get an Excel file name

Anonymous — Thu, 26 Dec 2019 03:09:34 GMT

In the Context view, you can define a variable. To use a variable, the format is: context.varName
Can you please explain why the file name is a dynamic name in your case? So that I can give you an accurate answer.

Re: How to Dynamically get an Excel file name

Anonymous — Thu, 26 Dec 2019 06:23:53 GMT

Hi,
Thanks for your reply,
I want to read the files from a folder. The filename should be changed dynamically like
report(1).xlsx
report(2).xlsx
report(3).xlsx
How do I read the files from the folder? at the same time, I wants to store the read file name into the table.

Re: How to Dynamically get an Excel file name

Anonymous — Thu, 26 Dec 2019 10:05:21 GMT

You just need to use a tFileList to iterate each file in the specified folder, this component pre-define some global variables which you can use on other components, includes:
file path: (String)globalMap.get("tFileList_1_CURRENT_FILE"))
file name: ((String)globalMap.get("tFileList_1_CURRENT_FILEPATH")).
The job design looks like:
tFileList--iterate--tFileInputExcel--main--tMap-->

Hope it helps you!

Regards
Shong