topic load data from text files under this format in QlikView https://community.qlik.com/t5/QlikView/load-data-from-text-files-under-this-format/m-p/1628433#M733711 <P>Hello!<BR /><BR /></P><P>I have multiple files which got data under the below format. How I can import it to qlikview?</P><P>{<BR />"jobID" : 4444,<BR />"requestId" : "aaa-bb-ccc:00001122454",<BR />"deliveryPoints" : [ {<BR />"commsUnit" : 55142,<BR />"finishpointId" : "00-aaa"<BR />} ],<BR />"numberOfInImage" : 100,<BR />"numberOfUnit" : 1,<BR />"jobStartDate" : 1564739540012,<BR />"startDate" : 1564393352680,<BR />"estimatedCompletionDate" : 1565069317608,<BR />"stopDate" : 1564739540012,<BR />"jobState" : "EXPIRED",<BR />"completedUnit" : 0,<BR />"loadStartsSent" : 0,<BR />"loadStartsReceived" : 0,<BR />"Cycle" : 0,<BR />"BlockNumber" : 0,<BR />"imageChecksSent" : 0,<BR />"imageChecksReceived" : 0,<BR />"missingBlocksSent" : 0,<BR />"expiredDuringState" : "QUEUED",<BR />"hostname" : [ "blbla-blal" ],<BR />"missingBlocks" : 0,<BR />"totalBlocks" : 0,<BR />"failedCommsUnit" : [ {<BR />"repId" : 55142,<BR />"state" : "ACCEPTED",<BR />"stateDetail" : "ACCEPTED"<BR />} ]<BR />}</P><P>I have over 1000 text files to process in that format how I can do this in qlikview?</P><P>Thanks in advance!&nbsp;</P> Sat, 16 Nov 2024 02:23:03 GMT 0li5a3a 2024-11-16T02:23:03Z load data from text files under this format https://community.qlik.com/t5/QlikView/load-data-from-text-files-under-this-format/m-p/1628433#M733711 <P>Hello!<BR /><BR /></P><P>I have multiple files which got data under the below format. How I can import it to qlikview?</P><P>{<BR />"jobID" : 4444,<BR />"requestId" : "aaa-bb-ccc:00001122454",<BR />"deliveryPoints" : [ {<BR />"commsUnit" : 55142,<BR />"finishpointId" : "00-aaa"<BR />} ],<BR />"numberOfInImage" : 100,<BR />"numberOfUnit" : 1,<BR />"jobStartDate" : 1564739540012,<BR />"startDate" : 1564393352680,<BR />"estimatedCompletionDate" : 1565069317608,<BR />"stopDate" : 1564739540012,<BR />"jobState" : "EXPIRED",<BR />"completedUnit" : 0,<BR />"loadStartsSent" : 0,<BR />"loadStartsReceived" : 0,<BR />"Cycle" : 0,<BR />"BlockNumber" : 0,<BR />"imageChecksSent" : 0,<BR />"imageChecksReceived" : 0,<BR />"missingBlocksSent" : 0,<BR />"expiredDuringState" : "QUEUED",<BR />"hostname" : [ "blbla-blal" ],<BR />"missingBlocks" : 0,<BR />"totalBlocks" : 0,<BR />"failedCommsUnit" : [ {<BR />"repId" : 55142,<BR />"state" : "ACCEPTED",<BR />"stateDetail" : "ACCEPTED"<BR />} ]<BR />}</P><P>I have over 1000 text files to process in that format how I can do this in qlikview?</P><P>Thanks in advance!&nbsp;</P> Sat, 16 Nov 2024 02:23:03 GMT https://community.qlik.com/t5/QlikView/load-data-from-text-files-under-this-format/m-p/1628433#M733711 0li5a3a 2024-11-16T02:23:03Z Re: load data from text files under this format https://community.qlik.com/t5/QlikView/load-data-from-text-files-under-this-format/m-p/1628628#M733712 <P>Hi,</P><P>try to see file attached</P> Thu, 26 Sep 2019 13:38:55 GMT https://community.qlik.com/t5/QlikView/load-data-from-text-files-under-this-format/m-p/1628628#M733712 StarinieriG 2019-09-26T13:38:55Z Re: load data from text files under this format https://community.qlik.com/t5/QlikView/load-data-from-text-files-under-this-format/m-p/1628790#M733713 <P>Amazing, many thanks!</P> Thu, 26 Sep 2019 19:48:56 GMT https://community.qlik.com/t5/QlikView/load-data-from-text-files-under-this-format/m-p/1628790#M733713 0li5a3a 2019-09-26T19:48:56Z