Solved: Derive new field from table - Qlik Community

nihhalmca · ‎2017-07-04

Hi All,

I need to be derived new field from table at script level.

Please have a look at attachment for details.

Thanks,

Nihhal.

PrashantSangle · ‎2017-07-04

Hi,

try below

Load * from YourTable;

Left Join

Load EMPID as MANAGERID,ENAME as MANAGERNAME from YourTable;

Regards,

Prashant

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

View solution in original post

PrashantSangle · ‎2017-07-04

Hi,

try below

Load * from YourTable;

Left Join

Load EMPID as MANAGERID,ENAME as MANAGERNAME from YourTable;

Regards,

Prashant

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

ahaahaaha · ‎2017-07-04

Hi,

May be like this (look attached file)

FieldValue('ENAME', FieldIndex('EMPID', MANAGERID))

Regards,

Andrey

nihhalmca · ‎2017-07-07

Thanks Prashant.

nihhalmca · ‎2017-07-07

Hi Andrey, thanks for your kind response and attachment.

Actually i expected at script level.