Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Save $650 on Qlik Connect, Dec 1 - 7, our lowest price of the year. Register with code CYBERWEEK: Register
cancel
Showing results for 
Search instead for 
Did you mean: 
sumitk
Partner - Creator
Partner - Creator

JSON Column Extraction

Hi All,

While I am extracting the data from the table available in DB there is a JSON column in table, If I excluded that JSON column then my complete table extraction done within 2 Minutes but when I include that JSON column it is taken more than 4 hours to extract complete table.

Please suggest me a solution to perform faster extraction including JSON column.

Thanks in advanced.

Labels (6)
1 Reply
ajaykakkar93
Specialist III
Specialist III

Hi,
You can use JsonGet() method to get specific data from json
example:
JsonGet(og,'/proposerDetail/member/relationship') as [_proposerDetail_member_relationship],

Please mark the correct replies as Solution. Regards, ARK
Profile| GitHub|YouTube|Extension|Mashup|Qlik API|Qlik NPrinting