AMDP Transformation - Select first

[former_member237224]

Hi everyone,

In a transformation I am using a field AMDP routine.

Here is the scenario:

Let's say this is the input data

NAME | CITY | SYSTEM
---------------------------------
name1 | Vienna | TBW
name 2 | Berlin | QBW
name 3 | Budapest | PBW

I want to select the name and city depending on the system name. when the system is TBW then select this, else select the first line.

The field should be filled like this:

NAME | CITY | SYSTEM

---------------------------------
name1 | Vienna | TBW
name 2 | Berlin | QBW

Thank you