tFileList : read excel files but it seems that it can't read the worksheet even if I used ((String)globalMap.get("tFileInputExcel_1_CURRENT_SHEET"))

[citrods]

Hello

I have a folder wiith sub-folders. Some of them contains an excel files and i want to read all the excel files.

 

I also want to write the filepath and the worksheet so that I know what files i'm reading.

Here is the job I created :

For tfilelist, in the settings, i specified the folder and specified that i want to read xlsx files.

 

For tfileinputexcel, in he settings, i specified the filepath with a global variable : ((String)globalMap.get("tFileList_1_CURRENT_FILEPATH"))

 

in order to get the filepath, the filename and the worksheet, i used a tmap and here are my settings:

 

in the output file, the filepath and the filename are written.

however the 3rd column is empty whereas the current sheet should be written.

is there an issue with ((String)globalMap.get("tFileInputExcel_1_CURRENT_SHEET")) ?

 

thank you

[Anonymous]

Hello,

What's talend solution are you using? Open studio or subscription solution?

Are you using Memory option in tFileInputExcel component? Memory-consuming (User mode)?

Best regards

Sabrina

[citrods]

hello

I'm using talend open open studio

i checked the seetings in the memory option and actually, i selected the less-memory consuming mode.

I just tried to change for Memory-consuming (User mode) and it works now.

strange, do i have to always use Memory-consuming (User mode)?

I wanted to use the less-memory consuming mode when i have big files if possible

[Anonymous]

Hello,

The component tFileInputExcel might performs differently while using it in Less memory consumed for large excel(Event mode) vs Memory-consuming (User mode).

We will make an investigation on your issue and then come back to you as soon as we can.

Best regards

Sabrina