How to add another columns by extract specific value in the existing columns

[Anonymous]

Dear, Community 

i want to extract the value in columns to add to new columns : i just want to extract the value that not contain PP - or KP- 

how can do that i think both can be doing by Base on it key or by the value in Column[Place] which it some value containt '' - " 

Key	Places	New < columns>
BBK	Phnom Penh	Phnom
BBK	Kompot	Kompot
BBK	Poipet	Poipet
CNN	PP - Toul Kork
TDD	VN - Beung Keng Korng
DTD	KP - Terk Chou

[tamerj1]

Hi @Anonymous 
Here is a sample file with the solution https://www.dropbox.com/t/UpdJBIaJqjoGUM3F

New Column = 
VAR Items = SUBSTITUTE ( Data[Places], " ", "|" )
RETURN
    IF ( 
        Data[Key] = "BBK",
        PATHITEM ( Items, 1 )
    )

[Anonymous]

@tamerj1  

I don't want a substiute i just want to extract  Full Value ( Phnom Penh is still Phnom Penh) the only value where the Key = BBK  

[tamerj1]

@Anonymous 
Then it would be

New Column = 
IF ( 
    Data[Key] = "BBK",
    Data[Places]
)

[Anonymous]

@tamerj1 

it works but only for one key "BBK", so what if i want extract multiple value :

There a Parent key , code and name

As you see the picture under the Parent key we have BB1--> hold "

BB-BATTAMBANG

BB-MOUNG RUESSEI

BB-BAVEL

"

And Code BB1 --> "BATTAMBANG RO"

It simply word i could say that BATTAMBANG RO is a Country and the BB- above is a City but it just store in one columns separate by Parent key and code 

[tamerj1]

Hi @Anonymous 
Kindly provide the expected output with esplanation based on this screenshot. Thank you 

[Anonymous]

@tamerj1 

here is a expected output should look like

BB1	BATTAMBANG RO	BB-BATTAMBANG
BB1	BATTAMBANG RO	BB-MOUNG RUESSEI
BB1	BATTAMBANG RO	BB-BAVEL

[tamerj1]

@Anonymous 
It seems I'm I am unable to undestand your requirement. My apologies. Maybe we can connect via Teams or zoom for better understanding. Please let me if you are aviable for a quick meeting. Thank you