Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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 |
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 )
)
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
@Anonymous
Then it would be
New Column =
IF (
Data[Key] = "BBK",
Data[Places]
)
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
Hi @Anonymous
Kindly provide the expected output with esplanation based on this screenshot. Thank you
here is a expected output should look like
BB1 | BATTAMBANG RO | BB-BATTAMBANG |
BB1 | BATTAMBANG RO | BB-MOUNG RUESSEI |
BB1 | BATTAMBANG RO | BB-BAVEL |
@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
User | Count |
---|---|
41 | |
27 | |
23 | |
18 | |
15 |
User | Count |
---|---|
54 | |
35 | |
19 | |
18 | |
15 |