Hi all,
What I need in this case is if the folder has an excel file then the above missing value should be removed.
If we don’t have an excel file in the folder that’s totally fine if we get a missing value.
Can someone please suggest some logic to do that?
Regards
Sathya
Hello @sathya_159
You can use a ‘Row Filter’ node with: contain wildcard ‘*.xlsx’
and send the result to an ‘Empty Table Switch’
Regards
thanks, @gonhaddock can you show one example for this!!
@sathya_159
This is the idea…
20211026_handling_missing.knwf (39.2 KB)
You may have to to Group Loop over ‘Form No’
Thanks again @gonhaddock for your solutions :slight_smile, I will revert back in a few hours once I have checked the results since it’s very late here. Thanks a lot!
Just in case… please find the group loop implemented
20211026_handling_missing_v2.knwf (56.7 KB)
Thanks @gonhaddock .
Can you suggest ideas on this if possible please.
[image]
Hi all,
Can somebody suggest some logic or rule set, wherein above case say a Vessel(VSL 1) submits 10 forms in form of excel namely (i.e 1.xlsx to 10.xlsx) considering form 3,5,7 submission is 3 monthly interval and rest all forms submission is every month.
What is required is that once the excel is captured (by list files and folder node) & we do know submission intervals (i.e 1 or 3 monthly) we should be able to check for the next submission data automatically considering Septembe…
system
Closed
April 27, 2022, 8:44am
9
This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.