4 Replies Latest reply: Nov 29, 2017 3:40 AM by Irmantas Tubutis RSS

    Problems with Applymap

    Irmantas Tubutis

      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

      [J:\issiusta.xlsx]

      (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.