Removing data from an excel sheet

[markbanlawe]

i would like to remove the data from an existing sheet through a workflow and then updating that same sheet with blank data

Example:

Sheet 1

Output to Sheet1

[DataNath · Accepted solution]

@markbanlawe yep - where I said make sure to choose 'Overwrite File (Remove)' above, just change this to the following option instead:

When you're picking the file on initial setup and you're prompted for the sheet number, just make sure you specify the same sheet that's coming in as the input.

[ARussell34]

You should be able to use a Multi-Field Tool and select all the columns you want to update to be blank and either use the statement Replace([_CurrentField_], [_CurrentField_], "") or just plainly update the Expression to "". Make sure to un-check the box stating you want all updated columns to output with a "new" as the prefix.

[markbanlawe]

thank you all for the reply and guidance

[KrishnaChithrathil]

@markbanlawe Please accept whichever posts helped you, as a solution. It'll help others as well. 

Good day.!