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.

Error Handling - Missing Table

Adangel
5 - Atom

I have an app where the user is requested to provide an Access database file, at which point an Input Data tool tries to import a few specific tables.

 

If one of the tables doesn't exist, the app ceases and Alteryx provides an error message stating as much. Is there a way to customize this error message? And(or) have the app ignore the error and continue if at least one of the tables successfully imported?  

3 REPLIES 3
gabrielvilella
14 - Magnetar

Maybe if you have a chained app, the first one reads all tables names from the file and checks which tables are present. Then, considering that you have one Input data tool for each table name, the second app enables or not containers that has those input data tools based on the list of tables from the first app. 

Adangel
5 - Atom

Is there a way to obtain a list of table names without using MsysObjects?

gabrielvilella
14 - Magnetar

I am sorry, I am not that familiar with  Access database files. Maybe someone else here can answer this. 

Labels
Top Solution Authors