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?
just connection for iterate from tFileList
normally RunIf fire when component finish work, so on each iteration when empty tJavaFlex finish it zerro work it fire a trigger for each iteration, but not once when tFileList finish it work
why You just not use filename pattern for tFileList?
"*FileType1*"
and then iterate over all matched files
If you mean using the filemask to only select files to be read? I need to process all the files but I need to process some differently depending on their structure (there is a reason why they are in the same folder). Wouldn't having multiple tFileLists on the same folder open the possibilities of file locks?
If you mean using the filemask to only select certain files to be read? I need to process all the files but I need to process some differently depending on their structure (there is a reason why they are in the same folder). Wouldn't having multiple tFileLists on the same folder open the possibilities of file locks?
ok, in this case:
tJavaFlex - empty
RunIf - Your condition
tFixedFlowInput - replace with tExcelInput
My 1st problem is that my If condition doesn't evaluate to True. Any advice how i debug that?
as you can see from screenshot - it work
so, check your condition and real filenames pattern,
is it really contain -
FileType1
?
What is the purpose of the tJavaFlex? The run if works now (copied from my original process) but I swear it doesn't if you have the tFileList ---RunIf--tFileInputExcel
just connection for iterate from tFileList
normally RunIf fire when component finish work, so on each iteration when empty tJavaFlex finish it zerro work it fire a trigger for each iteration, but not once when tFileList finish it work
Can I ask a follow up how you could join (Unite) the flows into 1 flow once any custom processing had been completed?