Join (if input file is blank)

[_gavinloi_]

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.

[aatalai]

@_gavinloi_ check out the crew macros and look for thing like the conditional runner tool

http://www.chaosreignswithin.com/p/macros.html

[binu_acs · Accepted solution]

@_gavinloi_ you can create some dummy records if your lookup file is empty based on the record count. Sample workflow attacched