How to Dynamically get an Excel file name

[Anonymous]

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?

[Anonymous]

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

[Anonymous]

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

[Anonymous]

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.

[Anonymous]

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.

[Anonymous]

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.

[Anonymous · Accepted solution]

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