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

[DataNath · Accepted solution]

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!

[aschoen]

This seems to have worked. Thank you