Editing Text Input Table in the Analytic App

Question

Hi there, I have a predefined text input table in my workflow with Currency rates that I want the user to be able to update every time the workflow is ran but just not sure how to do it with the text box tool.

Updating one cell is fine but I would want the user to be able to view the table and make any needful changes, lets say update current rate or add new currencies (new rows) which then gets joined onto the main data.

please help!

Capture.PNG

apatel1501 · Answer

I'm also looking for this functionality.  If not possible, would be a good addition for alteryx to be able to add a text input table with cells into the interface.  I am using a file input right now, but if the user doesn't know the necessary columns - it becomes less intuitive.  Ideally, they can update cells and add rows etc within the interface.

Shoaib345 · Answer

UPDATE currency_table

SET current_rate = CASE

WHEN currency_code = 'USD' THEN 1.15

WHEN currency_code = 'EUR' THEN 0.95

ELSE current_rate

END

WHERE currency_code IN ('USD', 'EUR');

Bazal · Answer

Thanks for sharing this Bren but this was not of much help.

I am trying to build the functionality to allow the user to edit the existing values and add more cells to the existing columns if needed; all in the app screen itself.

This is the text input table that I have and needs manipulating on every run.

capture.PNG