How to replace repeated fields in a column with blanks leaving unique row.

Question

Hello Team,

I am looking to remove repeated fields in a row with blanks as shown below.

Input -

Test1Test2Test3Test4Test5Test6Test7Test8Test9111112121212024 06Y6/12/20066/12/2024BeneficiaryY2024222212121212024 06Y6/12/20066/12/2024BeneficiaryY2024333312121212024 06Y6/12/20066/12/2024BeneficiaryY20244444232323232024 07Y5/3/20066/12/2024Beneficial OwnerY20245555232323232024 07Y5/3/20066/12/2024Beneficial OwnerN20246666232323232024 07Y5/3/20066/12/2024Beneficial OwnerN20247777232323232024 07Y5/3/20066/12/2024Beneficial OwnerY20248888344455452024 08Y7/21/20067/21/2024NomineeY20249999344455452024 08Y7/21/20067/21/2024NomineeY2024878787344455452024 08Y7/21/20067/21/2024NomineeY2024878788344455452024 08Y7/21/20067/21/2024NomineeY2024878789344455452024 08Y7/21/20067/21/2024NomineeY2024878790898989892024 09Y9/2/20069/2/2024BeneficiaryY2024878791898989892024 09Y9/2/20069/2/2024BeneficiaryY2024878792898989892024 09Y9/2/20069/2/2024BeneficiaryY2024878793898989892024 09Y9/2/20069/2/2024BeneficiaryY2024878794454545452024 10Y9/16/20069/16/2024Beneficial OwnerY2024878795788777882024 11Y6/30/20066/30/2024NomineeY2024

Required output -

Test1Test2Test3Test4Test5Test6Test7Test8Test9111112121212024 06Y6/12/20066/12/2024BeneficiaryY20242222        3333        4444232323232024 07Y5/3/20066/12/2024Beneficial OwnerY20245555        6666        7777        8888344455452024 08Y7/21/20067/21/2024NomineeY20249999        878787        878788        878789        878790898989892024 09Y9/2/20069/2/2024BeneficiaryY2024878791        878792        878793        878794454545452024 10Y9/16/20069/16/2024Beneficial OwnerY2024878795788777882024 11Y6/30/20066/30/2024NomineeY2024

HomesickSurfer · Answer

Hi @Saravanan13

Revised flow attached.

group tests.yxmd

Saravanan13 · Answer

Thanks for the reply, One issue with your output is in test1 column I need all values. One field in test 2 can be linked to multiple fields in test1. Can you fix it. Please refer to the required output

HomesickSurfer · Answer

Hi @Saravanan13

Here's how I'd do it with Mode and several Group By actions, matching with record Id and then sorted.

Workflow attached.

Note:  your expected results are incorrectly excluding the 5555 Test1 as a similar Test8 has a value of 'Y'.

group tests.yxmd