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

[KrishnaChithrathil]

@markbanlawe 

Is there any condition check?

[markbanlawe]

no there is none

[JamesCharnley]

Hi @markbanlawe,

This should work, if it's all fields then just apply a multi-field formula to all columns and create some kind of formula to change it to blank. You'd then be able to output just the fields you want from here. I used the formula: REGEX_Replace([_CurrentField_], '.*', '')

(You can untick the box that says 'Copy output fields and add' to just update the fields)

Edit: Missed that same sheet requirement! The solutions provided below with Block Until Done and the Output options should work perfectly.

[DataNath · Accepted solution]

@markbanlawe how does this look?

Before run:

After run:

After bringing in the data, we just use a Multi-Field Formula tool with all fields selected to null everything:

In the Output Data config, we then just select the incoming file and make sure to set option 3 to 'Overwrite File (Remove)':

[KrishnaChithrathil]

@markbanlawe 

How about this?

Specifying the same sheet name.

[markbanlawe]

Thank you and my apologies i forgot to mention that i have other sheets that cannot be we cannot override therefore it would only be a that sheet to edit. Is there any changes to the solution?

[JamesCharnley]

If you're only inputting that one sheet and outputting to the same one, none of the other sheets should be affected!

[ShankerV]

@markbanlawe Yes, you have a solution.

After the multi field formula tool, insert a Block until done tool.

Then overwrite on the same file and same sheet1 without affecting the other sheets.

Many thanks

Shanker V

[KrishnaChithrathil]

@markbanlawe 

like @JamesCharnley said none of the other sheets would get affected.