cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
TommyD91 New Member
New Member

Removing duplicated text across 2 columns using power query

Hi,

 

I have a bit of an odd query which I hope one of you specialists can assist me with.

 

I use PowerQuery with SalesForce and I am trying to use it to align some of our account territories.

 

I currently have a table that looks like this,

 

 Capture.PNG

 

this is accounts that I want to change associated territories of. I want row 2 to have only in the territory to drop field, ";TM DD 4;DD Field 4;" and I want territory to add to be blank as i do not need to add the DD 5 territory, it is already there.

 

Is there a way that power query can parse the rows and recognise duplications between the semi colon delimiters and remove if they appear in both territory to drop and territory to add. Essentially, I don't want to be dropping and adding the same territories.

 

Any help on this would be vert much apreciated.

1 REPLY 1
Community Support Team
Community Support Team

Re: Removing duplicated text across 2 columns using power query

Hi 

I would suggest you to consider the operation "Split columns", funtion 'Text contains".

 

Best Regards

Maggie