Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
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