Row Level Merge and delete

[Datology]

Hello All,

I have the following data set

When a UNIT has a SUB_UNIT A that matches with a SUB_UNIT B. I need to remove the SUB_UNIT B row and replace the A with a W. One UNIT and SUB_UNIT can only be matched with one other UNIT and SUB_UNIT. So the result should look like this...

Is there any way to do this outside of using Python?

Appreciate any help you can give!

[Qiu]

@Datology 

I dont know about Python, so this is an Alteryx way, if that is what you need.

[Datology]

My apologies, I forgot to mention that there would be multiple account numbers that must remain separate...

[Qiu]

@Datology 
That workflow should work for that.
and please provide the input in data format, not picture...

I have to spend time to input them...

[Datology]

Sorry about that. The .yxdb input data is attached.

It looks like it's trying to combine between the account numbers...

[Qiu · Accepted solution]

@Datology 
Thnak you for the input data.

Your new input indeed requires some addtional settings.

Kindly see this works for you.

[Datology]

All I needed to do was select Account# in First 1 and it seems to work perfectly!

Thank you so much for your help! I'm kind of new to the forums so is there anything I can do besides clicking the "Accept Solution" to help you?

[Qiu]

@Datology 
Its very of you to give comment as this.

I am just glab to help and thank you for the accept also. 😁