Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

[resolved] Read same excel few times and send to tMap

Hello, i wanna iterate some excel but reading each one few times and send the results into a tMap. I use ((String)globalMap.get("tFileList_1_CURRENT_FILEPATH")) like file name in both files.

I get the next error:tFileInputExcel_2
java.lang.Exception: The data source should be specified as Inputstream or File Path!

Is it posible??
0683p000009MGCU.jpg

Labels (2)
1 Solution

Accepted Solutions
vapukov
Master II
Master II

It possible with little trick 0683p000009MACn.png

add tJavaFlex component and store current filename into it
than on lookup file use context variable, but not -  ((String)globalMap.get("tFileList_1_CURRENT_FILEPATH"))


0683p000009MGKE.png  0683p000009MGKI.png

View solution in original post

2 Replies
vapukov
Master II
Master II

It possible with little trick 0683p000009MACn.png

add tJavaFlex component and store current filename into it
than on lookup file use context variable, but not -  ((String)globalMap.get("tFileList_1_CURRENT_FILEPATH"))


0683p000009MGKE.png  0683p000009MGKI.png
Anonymous
Not applicable
Author

Thanks!!!!!!