Error Message

[naziralala]

Hello All,

I am getting the error message in Netezza as below when i try to use the applymap function.

Can someone help me resolve this issue.

Netezza Performance server

Applymap(unknown, int8)does not exist.

You need to add explicit typecasts.

Regards,

Nazira

[naziralala]

Hello,

This does not give an error, but does not give any data- Dept name in Dept_3_4

Thanks.

[marcus_sommer]

I think the syntax from lookup isn't correct, try instead:

lookup('Dept Name','Dept_key', Dept_key,'Department')

also I'm not sure if it's the proper logic, maybe rather so:

lookup('Dept_key', 'Dept Name', Dept_key,'Department')

- Marcus

[naziralala]

Hello Michael,

Now by replacing lookup instead of applymap, i am not getting any error but

the field names are not getting displayed.

Now, what can be the issue?

Department:

Load Dept_key, Dept_nm as "Dept Name";

Sql select Dept_key, UPPER(Dept_nm) as "Dept_nm"

from cdw.department;

UrgentCare:

Load Acct_Key, Dept_key,

lookup('[Dept Name]','Dept_key', 'Dept_key','Department')as 'Dept_3_4'

from cdw.urgentCare;

On Mon, Apr 27, 2015 at 7:22 PM, Michael Solomovich <