Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
sumitk
Partner - Contributor III
Partner - Contributor III

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