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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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