Alteryx Designer Desktop Discussions

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

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

James_Rowley
6 - Meteoroid

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?

5 REPLIES 5
WillTravelForData
8 - Asteroid

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.

 

James_Rowley
6 - Meteoroid

hello,

 

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

WillTravelForData
8 - Asteroid

 

 

 

WillTravelForData
8 - Asteroid

I finally got it figured out, I think.

 

 

possible solution.PNG

 

 

 

 

 

 

Ignoring Missing Data Connection for Union Tool

James_Rowley
6 - Meteoroid

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

Labels