Task

[ShashiRanjan]

Hi,

This is my input table which contains ID, Name, and ManagerID.

And my requirement is to create a table which contains ID, Name, ManagerID, and ManagerName.

[Anil_Babu_Samineni]

If you show this table, I can think this way

If(Manager_ID = 1, 'A', Null()) as Manager_Name

[StarinieriG · Accepted solution]

Hi,

you could create the field inside script

LOAD * FROM TABLE;

Left Join

LOAD 

ID as ManagerID,

Name as ManagerName

Resident TABLE;

[ShashiRanjan]

Thanks  StarinieriG that worked perfectly.