Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
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