use DML statements like update, insert & select SQL queries

[Onkar Suryawanshi]

As I was building a workflow where I'm passing ID of a specific record from a excel or csv file and the that ID I have to pass to a SQL query like

"update user_shareable set is_deleted = FALSE, deleted_by_id = NULL where id = 123"

Here in this SQL query I have passed the ID from excel file.

How can we achieve this in alteryx workflow??

[alexnajm]

Read in the Excel, and pass the value into your query using a Dynamic Input tool!

[alexnajm]

Like this: https://knowledge.alteryx.com/index/s/article/Modifying-SQL-Query-using-the-Dynamic-Input-Tool-15834...