This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I am trying to turn one of my workflows into an analytic app and am having trouble with the folder browse tool. I am connecting to an ESRI File Geodatabase and can choose the database easily enough, what I cannot do is choose a table from within that database. I can't figure out which tool to use to access the dialogue box for choosing the table. I would appreciate any help or comments.
That's a great help! However, I am having trouble figuring out how to read the database tables. ESRI File Geodatabases use a proprietary format. Alteryx has the API which is how it can read the table names in the geodatabase, but I can't figure out how to do it via a query as in this example. The list of tables is stored in the highlighted file (I tried to attach it, but it didn't have a valid extension) This file will appear in each geodatabase and contain all the tables (layers). Here's a little overview of more of the folder structure. The main problem is trying to work with the geodatabase outside of ArcGIS or ESRI's API, but I don't know another way to approach it.
Thank you MarqueeCrew for putting me on the right track, and Alteryx Support Engineer Wizard Ozzie for helping me work out the bugs.
The workflow is a lot more convoluted than I expected, but it works. The key to the workflow is that the a000000001.TablesByName.atx file is the index file for any ESRI File Geodatabase and the file name is the same for every geodatabase so only the path needs to be changed. The first app in the workflow parses and cleans up the file into a list of layer names as well as outputting the path to the geodatabase.
The second step used a drop down that's populated by the first step and concatenates the file path with the layer name in order to open up the geodatabase and save it as an Alteryx database that can be used in any workflow.
I have attached the workflow for those that are interested in looking deeper. If anyone can find a more elegant solution, I would be very interested. If anyone wants a geodatabase to play around with and does not use them often here is a link to some sample geodatabases.