Removing data from an excel sheet
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
Solved! Go to Solution.
- Labels:
- Output
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
no there is none
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@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)':
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
If you're only inputting that one sheet and outputting to the same one, none of the other sheets should be affected!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
like @JamesCharnley said none of the other sheets would get affected.