Hello All A big thank you to the wonderful Alteryx community for the great support. I have this question that would be grateful to get help for. Here is a toy data of transaction records which get generated by Workflow1. These are records which have failed some business logic checks. Workflow1 generates them by importing source data, running checks and then writing excel output of these records. Output includes an empty column called “Reviewer Comments”. RecordID Transaction Code Transaction Date Attribute_1 Attribute_2 Attribute_3 Test Result Reviewer Comments 1 A111 15/05/2019 41 366 1 Exception 3 A112 28/05/2019 11 119 2 Exception 4 A113 28/05/2019 20 458 2 Exception Now, user has to review these records and then provide comments in the “Reviewer Comments” column. After user’s data entry, these comments have to get updated to the same excel file. I created Workflow2 (screenshot below) to do this using a text input tool – but as you can see one has to run Workflow2 twice –first to enable the text input tool (so that the editing can be done), and then again to make sure the text input tool’s data (which would have the user comments) is updated back to the excel file. Is there a better or correct way to accomplish this? Thank you...

Enable user to edit and update records (almost equivalent to "writeback")

Hello All

A big thank you to the wonderful Alteryx community for the great support.

I have this question that would be grateful to get help for.

Here is a toy data of transaction records which get generated by Workflow1. These are records which have failed some business logic checks. Workflow1 generates them by importing source data, running checks and then writing excel output of these records. Output includes an empty column called “Reviewer Comments”.

RecordID	Transaction Code	Transaction Date	Attribute_1	Attribute_2	Attribute_3	Test Result	Reviewer Comments
1	A111	15/05/2019	41	366	1	Exception
3	A112	28/05/2019	11	119	2	Exception
4	A113	28/05/2019	20	458	2	Exception

Now, user has to review these records and then provide comments in the “Reviewer Comments” column. After user’s data entry, these comments have to get updated to the same excel file.

I created Workflow2 (screenshot below) to do this using a text input tool – but as you can see one has to run Workflow2 twice –first to enable the text input tool (so that the editing can be done), and then again to make sure the text input tool’s data (which would have the user comments) is updated back to the excel file.