topic Re: script in QlikView

script

Anonymous — Tue, 19 Sep 2017 09:35:09 GMT

Hi All,

below is the scenario , i want to get employee's manager's name in new columns. how can i achieve it in script

Re: script

Peter_Cammaert — Tue, 19 Sep 2017 09:40:52 GMT

Use a mapping table. Assuming that all intermediate managers are employees as well, everybody will occur once in the ename column.

MapEmp2Mgr:

MAPPING

LOAD ename, mname

RESIDENT OriginalTable;

Then use an applymap to translate the mname value into the managers name, like in

ApplyMap('MapEmp2Mgr', mname, '-') AS [new column],

You can do this using ID's as well, but maybe you'll need an extra JOIN or Mapping Table to translate final manager ID's into manager names.

Best,

Peter

Re: script

jonathandienst — Tue, 19 Sep 2017 09:47:09 GMT

You need to provide more information for meaningful help

Qlik Community Tip: Posting Successful Discussion Threads‌

Qlik Community Tip: How to Get Answers to Your Post

It would also be a good idea to upload a sample qvw containing some representative sample data (it need not be real, but must illustrate the data and your requirement.

Preparing examples for Upload - Reduction and Data Scrambling

Re: script

antoniotiman — Tue, 19 Sep 2017 09:54:42 GMT

Hi,

maybe like this

Temp:
LOAD * Inline [
eid,ename,mname,mid
1,sam,john,2
2,john,xyz,3
3,xyz,abc,4
4,abc,acc,5];
LOAD *,Lookup('ename','eid',mid,'Temp') as NewColumn
Resident Temp;
Drop Table Temp;

Regards,

Antonio

Re: script

hari8088 — Tue, 19 Sep 2017 10:12:57 GMT

Hi,

Try this.

Temp:

LOAD * Inline [

eid,ename,mname,mid

1,sam,john,2

2,john,xyz,3

3,xyz,abc,4

4,abc,acc,5];

map:

Mapping LOAD

eid as key,

ename

Resident Temp;

Final:

LOAD *,

ApplyMap('map',mid,'') as newmap

Resident Temp;

DROP Table Temp;