When filtered in one column, replacing all content in rest of columns with empty space

[Manjari]

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.

[patrick_digan · Accepted solution]

@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!

[Manjari]

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.

[danrh]

@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.

[Manjari · Accepted solution]

Hi @danrh,

Thank you for the reply. Your solution works like a charm.