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