Updating a FROM Clause using Input Data Tool

aschoen

I am in the process of building out a workflow that will pull data in from a database to do general profiling of that data. Currently, I am trying to use an analytical app that has a text box to update the FROM clause in the Input Data tool. This would specify which table to bring in data from the database. However, I cannot find a way to make the connection and return data from the database. Is it possible to use interface tools to update the FROM clause in Input Data tools?

Thanks

Dynamic FROM Clause.yxwz

DataNath

Hey @aschoen, if you set up your initial workflow with a simple Select * query like so:

In your Text Box's Action tool configuration, you can select the 'File - Value=' part and hit 'Replace a specific string' and then reduce it so it's only the table name:

Now if I run the app typing in the orders table, I get that:

Whereas if I type in superstore_people, I get that table, as the query is being updated with this value:

Hope this helps!