Talend Connect
Virtual Summit
JOIN US!
And visit the Customer
& Community Lounge.
May 27-28, wherever you are.

How can i get Excel sheet name in a job?

Highlighted
One Star

How can i get Excel sheet name in a job?

How can i get Excel sheet name in a job?
Highlighted
One Star
One Star

Re: How can i get Excel sheet name in a job?

Rxkang,

In a component after your tFileInputExcel you can use crtl + space and select something like the following: ((String)globalMap.get("tFileInputExcel_1_CURRENT_SHEET")) . (Depending on the name of your tFileInputExcel component offcourse)
Regards
Highlighted
One Star

Re: How can i get Excel sheet name in a job?

Hi,mpa
I didn't find " ((String)globalMap.get("tFileInputExcel_1_CURRENT_SHEET")) "
I only find :
((String)globalMap.get("tFileInputExcel_3_ERROR_MESSAGE"))
((Integer)globalMap.get("tFileInputExcel_3_NB_LINE"))
is our tos version problem?
Highlighted
One Star
One Star

Re: How can i get Excel sheet name in a job?

rxkang,
I would assume that this would be related with your tos version. What version are u using?
Regards
Highlighted
One Star

Re: How can i get Excel sheet name in a job?

Hi,mpa
I use TOS 3.1.1.

Do you have Msn No? we can talk with Msn. I am chinese.
Highlighted
One Star
One Star

Re: How can i get Excel sheet name in a job?

Rxkang,
I had a look and it seems to be added in version 3.2.
http://www.talendforge.org/bugs/index_jira.php?id=TDI-5407
Regards
Highlighted
Six Stars

Re: How can i get Excel sheet name in a job?

Do upgrade of TOS. First export from old version and then import repository to new version, this could help prevent issues when upgrading (comming from my experiences...)
Ladislav
Highlighted
One Star

Re: How can i get Excel sheet name in a job?

Do you mean i cann't get excel sheet name in version 3.1.1?
Highlighted
One Star

Re: How can i get Excel sheet name in a job?

Thank you ,archenroot
But , version is not compatible?
Highlighted
Six Stars

Re: How can i get Excel sheet name in a job?

As mpa wrote, feature CURRENT_SHEET has been added in version 3.2, so you schould use this version at minimal. It is not available in version 3.1.1.
Highlighted
One Star

Re: How can i get Excel sheet name in a job?

Thank you ,archenroot
How many years you used Tos, i am a new player. Can you give me a Skype or MSN?
I want to timely advice from you .May I be honored to make accqaintance with you?

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

Best Practices for Using Context Variables with Talend – Part 2

Part 2 of a series on Context Variables

Blog

Best Practices for Using Context Variables with Talend – Part 1

Learn how to do cool things with Context Variables

Blog

Migrate Data from one Database to another with one Job using the Dynamic Schema

Find out how to migrate from one database to another using the Dynamic schema

Blog