Qlik Sense Mapping

[#1]

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

[sasikanth]

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

[#3]

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:

Thanks and Regards,

Kamarul

[nizamsha]

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

[sasikanth]

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,