topic Re: Derive new field from table in QlikView

Derive new field from table

nihhalmca — Wed, 25 Nov 2020 16:16:04 GMT

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 — Tue, 04 Jul 2017 12:08:37 GMT

Hi,

try below

Load * from YourTable;

Left Join

Load EMPID as MANAGERID,ENAME as MANAGERNAME from YourTable;

Regards,

Prashant

ahaahaaha — Tue, 04 Jul 2017 12:21:39 GMT

Hi,

May be like this (look attached file)

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

Regards,

Andrey

nihhalmca — Fri, 07 Jul 2017 12:23:02 GMT

Thanks Prashant.

nihhalmca — Fri, 07 Jul 2017 12:24:18 GMT

Hi Andrey, thanks for your kind response and attachment.

Actually i expected at script level.