Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

Qlik Sense Mapping

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

4 Replies
sasikanth
Valued Contributor III

Re: Qlik Sense Mapping

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

Not applicable

Re: Qlik Sense Mapping

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

nizamsha
Valued Contributor

Re: Qlik Sense Mapping

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
Valued Contributor III

Re: Qlik Sense Mapping

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,






Community Browser