Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi guys,
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.
Please suggest.
Field name is
PublishedPDF |
thanks in advance
regards
Abhay singh
Try like these scenarios:
load binary in mysql load using HEX() function like this:
LOAD ...;
SQL SELECT
HEX(Id) as Id,
Name,
FROM table01;
OR
ODBC CONNECT TO [PetesDFM;DBQ=xe] (XUserId is eLNcfZFPTDdKWWZK, XPassword is eSfTSSRNMLaeGaROCE);
PeteDFM:
SQL SELECT IAMGE,
IMAGETYPE
FROM SYSTEM.QLIKVIEWIMAGES;
//info select imagetype, iamge from system.qlikviewimages;//-------- Start Multiple Select Statements ------
INFO SELECT IMAGETYPE, IAMGE FROM SYSTEM.QLIKVIEWIMAGES;
Refer this:
Hi Bala Thanks for reply,,.
tried this ,,,
LOAD ...;
SQL SELECT
HEX(Id) as Id,
Name,
FROM table01;
but its not working...
can you suggest this how i can use this ?
ODBC CONNECT TO [PetesDFM;DBQ=xe] (XUserId is eLNcfZFPTDdKWWZK, XPassword is eSfTSSRNMLaeGaROCE);
PeteDFM:
SQL SELECT IAMGE,
IMAGETYPE
FROM SYSTEM.QLIKVIEWIMAGES;
//info select imagetype, iamge from system.qlikviewimages;//-------- Start Multiple Select Statements ------
INFO SELECT IMAGETYPE, IAMGE FROM SYSTEM.QLIKVIEWIMAGES;
thanks