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

Announcements
Independent validation for trusted, AI-ready data integration. See why IDC named Qlik a Leader: Read the Excerpt!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

[resolved] ExtractJSON Fields

Hi Guys
Can anyone point me in the right direction with regards to setting up the Textractjsonfields component to suite my needs.
The Data I am receiving from TrestClient -> TLog is as follows:
Starting job JSON_to_CallStats at 09:55 26/05/2016.
connecting to socket on port 3912
connected
200||{
 "CallDistrDO.AnsDistrPerDay" : , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , ],
 "result" : , , , ]
}
disconnected
Job JSON_to_CallStats ended at 09:55 26/05/2016.

Please see screenshots of other settings.

Any help would be highly appreciated.
Regards
Labels (5)
1 Solution

Accepted Solutions
Anonymous
Not applicable
Author

Ok I managed to get it right.
See screenshots below
0683p000009ME1L.jpg 
0683p000009MEEI.jpg 
0683p000009MDyr.jpg

View solution in original post

3 Replies
Anonymous
Not applicable
Author

Apologies, thought images were attached.
0683p000009MEED.jpg 0683p000009MDt4.jpg 0683p000009ME74.jpg 0683p000009ME4T.jpg 0683p000009ME9Y.jpg
Anonymous
Not applicable
Author

Your format is - simply speaking - a misusage of the JSON format and you will not be able to extract these data in a simple way.
Anonymous
Not applicable
Author

Ok I managed to get it right.
See screenshots below
0683p000009ME1L.jpg 
0683p000009MEEI.jpg 
0683p000009MDyr.jpg