Mass update an excel file

[kgnott46]

I am new to Alteryx. I have someone who wants me to mass update data (over 200 lines) all at one time using a Alteryx workflow and a attached Excel file to the workflow. This is so that we don't have to filter line by line in the Excel file to make the updates as this would take a long time. Can you do this? 

I know you can use the Excel file as your data input and then maybe use a text input? 

[JBO]

Ok. I think I understand what you are attempting to achieve. Example flow attached.

1) Join the list of names with main database by the field that has the names. Important:  The names must be entered the exact same way in both lists for this to work correctly

2) Connect the Formula tool to the middle "J" output from the Join tool.

3) Use Formula tool to update the fields you want to change (I assumed you wanted the same value in all of the fields).

4) Use the Union tool to bring the purged rows with replaced field values back with the rest of the database.

5) Use the Output tool to export your updated spreadsheet.

Here is a screenshot. You can also download the sample flow below:

Hope this helps.

[kgnott46]

Thanks so much for your help, I will give it a try!