4 Replies Latest reply: Jun 15, 2016 5:16 AM by sasi k RSS

    Qlik Sense Mapping

    kamarul halifi

      Hi Guys,

       

      I'm using QlickSense and facing an error when using applymap on mapping as below:

      CONNECTs other than LIB CONNECT are not available in this script mode

       

      My script for the mapping is:

       

      MapdestinationAddresstoBookType:

      Mapping LOAD

           destinationaddr,

           BookType

      FROM [lib://1.4/BookSales.csv];

       

      ODBC CONNECT TO 'Hive TEST' (XUserId is xxx, XPassword is xxx);

             LOAD *,

            ApplyMap('MapdestinationAddresstoBookType', destinationaddr, null()) as BookType

      FROM HIVE."default"."testv2_view";

       

      Your feedback and assistance is highly appreciated.

       

      Best regards,

      Kamarul

        • Re: Qlik Sense Mapping
          sasi k

          Try this


          MapdestinationAddresstoBookType:

          Mapping LOAD

               destinationaddr,

               BookType

          FROM [lib://1.4/BookSales.csv];

           

          ODBC CONNECT TO 'Hive TEST' (XUserId is xxx, XPassword is xxx);

                 LOAD *,

                ApplyMap('MapdestinationAddresstoBookType', destinationaddr, null()) as BookType;


          SELECT *

          FROM HIVE."default"."testv2_view";

            • Re: Qlik Sense Mapping
              kamarul halifi

              Hi Sasi,

               

              Thanks for your prompt reply, much appreciated.

              I have to do the script that you give but still have no luck. Please find below screen captured:

              2016-06-15 16_40_04-Secured Network SAT _ Data load editor - Qlik Sense.png

               

              Thanks and Regards,

              Kamarul

                • Re: Qlik Sense Mapping
                  sasi k

                  Try this script

                   

                  MapdestinationAddresstoBookType:

                  Mapping LOAD

                      destinationaddr,

                      BookType

                  FROM [lib://1.4/BookSales.csv];

                   

                  LIB CONNECT TO 'Hive TEST' ;

                        LOAD *,

                        ApplyMap('MapdestinationAddresstoBookType', destinationaddr, null()) as BookType;


                  SELECT *

                  FROM HIVE."default"."testv2_view";


                  because you are executing this from qliksense so you should use LIB here and

                  also please check the connection of the above mapping load,






              • Re: Qlik Sense Mapping
                Nizam HM

                Your select statement is missing  in ur table that u r loading from some database

                 

                Your ODBC connection string is not accepting   the username and password there might be some gap in  your connection string

                create a new connection string and check the same