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: 
mobmsc2
Creator
Creator

Read file if file name contains

I have a folder of excel files, there is a common file naming scheme which indicates what schema should apply to the file. 

I am trying to use this Run If condition to connect the tFileList1 to an appropriate tFileInputExcel

((String)globalMap.get("tFileList_1_CURRENT_FILE")).contains("FileType1")

but the contents are not read, the if condition is returned false even though the filename contains the string.

 

I have tried 

 

tFileList ------tIterateToFlow --if- tFileInput

and 

tFileList ---if--tFileInput

 

Any ideas what I am doing wrong?

Labels (2)
10 Replies
vapukov
Master II
Master II

if data not too big - you could use tHash components for store intermediate result, if data big - better to store in local csv (or staging tables)

 

after this - create new subjob for read data from hash or csv/tables and combine them