Solved: Task - Qlik Community

ShashiRanjan · ‎2019-09-18

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.

StarinieriG · ‎2019-09-18

Hi,

you could create the field inside script

LOAD * FROM TABLE;

Left Join

LOAD

ID as ManagerID,

Name as ManagerName

Resident TABLE;

View solution in original post

Anil_Babu_Samineni · ‎2019-09-18

If you show this table, I can think this way

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

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful

StarinieriG · ‎2019-09-18

Hi,

you could create the field inside script

LOAD * FROM TABLE;

Left Join

LOAD

ID as ManagerID,

Name as ManagerName

Resident TABLE;

ShashiRanjan · ‎2019-09-19

Thanks StarinieriG that worked perfectly.

Task

General Question

Related Topics