Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator III
Creator III

load data from text files under this format

Hello!

I have multiple files which got data under the below format. How I can import it to qlikview?

{
"jobID" : 4444,
"requestId" : "aaa-bb-ccc:00001122454",
"deliveryPoints" : [ {
"commsUnit" : 55142,
"finishpointId" : "00-aaa"
} ],
"numberOfInImage" : 100,
"numberOfUnit" : 1,
"jobStartDate" : 1564739540012,
"startDate" : 1564393352680,
"estimatedCompletionDate" : 1565069317608,
"stopDate" : 1564739540012,
"jobState" : "EXPIRED",
"completedUnit" : 0,
"loadStartsSent" : 0,
"loadStartsReceived" : 0,
"Cycle" : 0,
"BlockNumber" : 0,
"imageChecksSent" : 0,
"imageChecksReceived" : 0,
"missingBlocksSent" : 0,
"expiredDuringState" : "QUEUED",
"hostname" : [ "blbla-blal" ],
"missingBlocks" : 0,
"totalBlocks" : 0,
"failedCommsUnit" : [ {
"repId" : 55142,
"state" : "ACCEPTED",
"stateDetail" : "ACCEPTED"
} ]
}

I have over 1000 text files to process in that format how I can do this in qlikview?

Thanks in advance! 

Labels (1)
1 Solution

Accepted Solutions
Highlighted
Partner
Partner

Hi,

try to see file attached

View solution in original post

2 Replies
Highlighted
Partner
Partner

Hi,

try to see file attached

View solution in original post

Creator III
Creator III

Amazing, many thanks!