topic PRN file in QlikView

PRN file

nareshthavidishetty — Mon, 07 Dec 2015 06:26:16 GMT

HI goodmorning all,

i have a requirement to do in qlikview the data file is .prn file format can any one know does qlikview supports the format

thanks

Naresh

Re: PRN file

HirisH_V7 — Mon, 07 Dec 2015 06:39:58 GMT

Hi Naresh,

Can You Post your Sample Data(.prn File)

Here it can be load like this,

Data:
LOAD Customer, 
     [Sales Order ID], 
     ShipDate, 
     Product, 
     Sales, 
     Quantity
FROM

(biff, embedded labels, table is [Sales Orders$]);

Hope this Helps,

PFA,

Regards,

HirisH

Re: PRN file

Kushal_Chawda — Mon, 07 Dec 2015 06:42:18 GMT

There are some utilities or tool available to convert the PRN to excel files. Then you can read the excel file into the QlikView. Just search in google ".PRN to Excel"

Re: PRN file

nareshthavidishetty — Mon, 07 Dec 2015 07:00:41 GMT

thanks for the reply