We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Join (if input file is blank)

_gavinloi_
5 - Atom

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.

2 REPLIES 2
aatalai
15 - Aurora

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

 

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

binuacs
21 - Polaris

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

image.png

Labels
Top Solution Authors