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

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable
‎2016-07-13 11:25 AM

How to extract JSON (multiline) child records?

Hello,
I have the following JSON metadata (see  attached picture).

As you can see, there are multiple "child" records for every main record.
The corresponding child records are arrays: ["2104-12-05T19:36:14Z","2104-12-05T19:37:49Z", ...etc] and ["Approved","Resolved",..etc]


This is my project (see attached picture)
It should extract records from ClearQuest using REST and copy then to SQL Server (doesn't work though as design is wrong because of the issue above).

What I need are single records to be inserted into the SQL Server database. Please advise.
Regards,
M.R.
0683p000009MFNH.png0683p000009MFW8.png

Labels (2)
Labels
181 Views
0 Likes
1 Reply
Anonymous
Not applicable
‎2016-08-01 04:26 AM
Author

Hi,
Sorry for delay!
Could you please post your expected result into forum?
Best regards
Sabrina
181 Views
0 Likes