Editing Text Input Table in the Analytic App

[Bazal]

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!

[Bren_Spill]

Can you change the currency table to a file input that user can update and then load in?

[Bazal]

Could be possible but in ideal word, I'd want changes to be happening only in the workflow. Also, even when using the file input, I'd expect the user to be editing the file in Alteryx 'shell' rather than in the excel/csv file separately. 

[Bren_Spill]

This might help: Solved: Let the user update a specific value in a column w... - Page 2 - Alteryx Community

[Bazal]

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.

[Shoaib345]

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');