Discussion board where members can get started with Qlik Sense.
I have to read binary data from database itself, like some data is converted into binary and stored in database tables,
i need to fetch this data into qlik and convert this data to tabular format.
i am attaching the sample data as well.
Field name is
thanks in advance
Try like these scenarios:
load binary in mysql load using HEX() function like this:
HEX(Id) as Id,
ODBC CONNECT TO [PetesDFM;DBQ=xe] (XUserId is eLNcfZFPTDdKWWZK, XPassword is eSfTSSRNMLaeGaROCE);
SQL SELECT IAMGE,
//info select imagetype, iamge from system.qlikviewimages;//-------- Start Multiple Select Statements ------
INFO SELECT IMAGETYPE, IAMGE FROM SYSTEM.QLIKVIEWIMAGES;
Hi Bala Thanks for reply,,.
tried this ,,,
but its not working...
can you suggest this how i can use this ?