Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
irmantas
Contributor III
Contributor III

Problems with Applymap

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.

1 Solution

Accepted Solutions
shraddha_g
Partner - Master III
Partner - Master III

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";

View solution in original post

4 Replies
shraddha_g
Partner - Master III
Partner - Master III

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";

tresesco
MVP
MVP

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";

antoniotiman
Master III
Master III

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";

irmantas
Contributor III
Contributor III
Author

Thank you ALL. It works now:)