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
@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)':
@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.
@markbanlawe
Is there any condition check?
no there is none
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.
How about this?
Specifying the same sheet name.
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?
@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
like @JamesCharnley said none of the other sheets would get affected.
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.
thank you all for the reply and guidance
@markbanlawe Please accept whichever posts helped you, as a solution. It'll help others as well.
Good day.!
