Hi all, I am stuck with a workflow. Currently the workflow would work on a daily basis if the 2 input files have data for the Join Function (for vlookup) however if 1 of the input file is empty, I would get an error as there would be no data to join(vlookup).Would there be any way to by pass the file (blank) or is there a walkaround for that issue that anyone has encountered before ? many thanks.
Solved! Go to Solution.
@_gavinloi_ check out the crew macros and look for thing like the conditional runner tool
@_gavinloi_ you can create some dummy records if your lookup file is empty based on the record count. Sample workflow attacched
User | Count |
---|---|
56 | |
27 | |
25 | |
23 | |
21 |