1 Reply Latest reply: Apr 5, 2013 12:01 AM by Johannes Sunden RSS

    ][SQL Server]'mixmatch' is not a recognized built-in function name.

      Get error msg:

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

       

      when executing the following script:

      MainFacData:

      SQL SELECT

      Customer,

      "Snapshot_Date"

      if(mixmatch(month("Snapshot_Date"),'Jan','Feb','Mar'),'1Q',

      if(mixmatch(month("Snapshot_Date"),'Apr','May','Jun'),'2Q',

      if(mixmatch(month("Snapshot_Date"),'Jul','Aug','Sep'),'3Q','4Q'))) as Quarter

       

      FROM "FISS_DM".Risk."RMD_Aggr_FISS_Facility"

       

      Anyone could help?

        • Re: ][SQL Server]'mixmatch' is not a recognized built-in function name.
          Johannes Sunden

          Hi Alex,

           

          Whatever you put between the SQL and the ; will be sent as a query to the database connection that you have open.

          You can't use QlikView functions as mixmatch as the database will not understand this syntax and throw the above error back to you. Only use proper syntax that is accepted by your database, in this case, T-SQL for SQL Server.

          QlikView functions can be applied in a load statement that uses the SQL statement as a data source like:

           

          Load

               A,     <- Mixmatch can go in here

               B;

          SQL Select

               A,

               B

          From tableX;