Help on if logic

[mahitham]

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

[swuehl]

Please only post a question once, not multiple times. It makes it hard to follow a discussion.

Help on if logic

[Anonymous]

Try the below:

IF(RIGHT(Key,3) = '693' or RIGHT(Key,3) = '983','Internal',IF(RIGHT(Key,3) = '988','External','Global')))