Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today
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

Re: load data from text files under this format

Hi,

try to see file attached

View solution in original post

2 Replies
Highlighted
Partner
Partner

Re: load data from text files under this format

Hi,

try to see file attached

View solution in original post

Highlighted
Creator III
Creator III

Re: load data from text files under this format

Amazing, many thanks!