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: 
dipanjan93
Contributor
Contributor

Extractions of columns from a JSON file

Hi Community,

 

I'm really confused that how would i extract the column names from a json file. These columns will then used to a create a table in PostgreSQL. Also, the records associated with these columns will further be used to populate the rows in that particular table. So could you please explain both the scenarios with proper screenshots.

 

For reference, please find the attached JSON file that i extracted from REST web-service.

 

Thanks in advance!

 

Best Regards,

Dipanjan

Labels (4)
1 Reply
Jesperrekuh
Specialist
Specialist

tExtractJSONFields and use jsonPath to retrieve data.
Google a bit on how jsonPath query works.