When filtered in one column, replacing all content in rest of columns with empty space
- 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
Hi All,
Requesting help in replacing all content in rest of columns with empty space, when filtered in one column.
This is the attached workflow, cannot proceed further.
I have attached the output too for reference in the same workflow.
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@Manjari Can you expand upon what you're trying to accomplish? I've made some assumptions and used a sort and multi-row field to accomplish what I think you're after. Hopefully this can point you in the right direction!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @Magnetar patrick_digan,
Thank you for the prompt reply, I do not want to delete or remove duplicates, after identifying duplicates I just want to replace couple of corresponding columns values by null or zero. So that the rows and columns i need retain as is. Let me know if you need more information.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@Manjari, you're almost there. Add a Select tool after the "T" output of your Filter, de-select the fields you want to null out from the list, and then Union back to your "F" output:
By removing the fields, they end up as null after the Union.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
![](/skins/images/D34B41DA407DC996E7BFF253AD24F7E2/responsive_peak/images/icon_anonymous_message.png)