Data Input - Update Database when there is a file to update

I was wondering if anyone could help me.

I have built a workflow that takes a master database and produces several reports for me.

I have also built into this workflow to update the master database beforehand with any new client files (which come in as a csv) before it produces the reports.

The issue I am having is when there are no files to update the master database with it obviously produces the error “cannot find the file” for the input of the additional files.

Is there a way to pull the info in only if there are files within the directory, and if there isn’t to just continue using the current master database?

Workflow for Alteryx.yxmd

Workflow

Input

Accepted answers

WillTravelForData

I finally got it figured out, I think.

possible solution.PNG

Ignoring Missing Data Connection for Union Tool

Workflow for Alteryx-Possible Solution.yxmd

All comments

WillTravelForData

I found this link that may be helpful: Stop workflow on a condition

JordanB's reply on ‎08-02-2017 01:53 AM describes the fix for avoiding the error.

hello,

thanks for this. But I need the workflow to continue, just against the Master database instead

WillTravelForData

I finally got it figured out, I think.

possible solution.PNG

Ignoring Missing Data Connection for Union Tool

Workflow for Alteryx-Possible Solution.yxmd

that has done the trick, thank you so much for your help.

Quick Links

Tags

This months top contributors

atcodedog05 19458

Qiu 15866

MarqueeCrew 13708

apathetichell 13703