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

Announcements
Only at Qlik Connect! Guest keynote Jesse Cole shares his secrets for daring to be different. Learn More!
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