topic Re: Problems with Applymap in QlikView

Problems with Applymap

irmantas — Wed, 29 Nov 2017 08:30:14 GMT

Hi folks,

I am using applymap first time, and stuck on it:)

I have this script:

Map_Nesiusti:

Mapping LOAD [Kliento kodas] as ACCOUNTNUM,

Nesiusti

FROM

(ooxml, embedded labels, table is Nesiusti);

ODBC CONNECT TO ax_dw;

SQL SELECT ACCOUNTNUM,

APPLYMAP('Map_Nesiusti',ACCOUNTNUM) as Nesiusti,

CREDITMAX,

CUSTGROUP,

PHONE

FROM "Litagra_DW".dbo."JG_V_CUSTTABLE";

AND have load error:

SQL##f - SqlState: 37000, ErrorCode: 195, ErrorMsg: [Microsoft][ODBC SQL Server Driver][SQL Server]'APPLYMAP' is not a recognized built-in function name.

SQL SELECT ACCOUNTNUM,

APPLYMAP('Map_Nesiusti',ACCOUNTNUM)as Nesiusti,

CREDITMAX,

CUSTGROUP,

PHONE

FROM "Litagra_DW".dbo."JG_V_CUSTTABLE"

Whats wrong? Please help on it.

Re: Problems with Applymap

shraddha_g — Wed, 29 Nov 2017 08:33:47 GMT

ODBC CONNECT TO ax_dw;

Try Below:

Load *,

APPLYMAP('Map_Nesiusti',ACCOUNTNUM) as Nesiusti

;

SQL SELECT ACCOUNTNUM,

CREDITMAX,

CUSTGROUP,

PHONE

FROM "Litagra_DW".dbo."JG_V_CUSTTABLE";

Re: Problems with Applymap

tresB — Wed, 29 Nov 2017 08:35:00 GMT

Applymap() is a qlik function and you can't use that under sql select. Try using it under load statement instead like:

Load

APPLYMAP('Map_Nesiusti',ACCOUNTNUM) as Nesiusti

;

SQL SELECT

ACCOUNTNUM,

CREDITMAX,

CUSTGROUP,

PHONE

FROM "Litagra_DW".dbo."JG_V_CUSTTABLE";

Re: Problems with Applymap

antoniotiman — Wed, 29 Nov 2017 08:35:24 GMT

LOAD *,APPLYMAP('Map_Nesiusti',ACCOUNTNUM) as Nesiusti;

SQL SELECT ACCOUNTNUM,

APPLYMAP('Map_Nesiusti',ACCOUNTNUM) as Nesiusti,

CREDITMAX,

CUSTGROUP,

PHONE

FROM "Litagra_DW".dbo."JG_V_CUSTTABLE";

Re: Problems with Applymap

irmantas — Wed, 29 Nov 2017 08:40:54 GMT

Thank you ALL. It works now:)