Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Experts,
Can any one please help me on below requirement.
I have the data like below.
Here same trade keys is in three Different Types i.e, Internal, External and Global.
Requirement is when any id present in Internal, External and Global Types need to keep that id in Internal Type
If there Is no Internal then need to keep in External else in Global.
Please help me on this. Thanks in advance
Input :
Key Type Identfier
1578693 Internal afv
1578693 External sf_erkil
1578693 Global huk_lop
1578983 Internal afv
1578983 External sg_kilo
1578988 Global hjkl
1578988 External siklo
15789698 Global olp
Expected Output:
Key Type Identfier
1578693 Internal afv
1578983 Internal afv
1578988 External siklo
15789698 Global olp
Please only post a question once, not multiple times. It makes it hard to follow a discussion.
Try the below:
IF(RIGHT(Key,3) = '693' or RIGHT(Key,3) = '983','Internal',IF(RIGHT(Key,3) = '988','External','Global')))