topic Re: Data file renaming. How? in QlikView

Data file renaming. How?

alexis — Wed, 27 Aug 2014 10:26:21 GMT

I receive CSV files that have a different file extension (DRR).

Is there an easy way of renaming these files before I process them as CSVs . QlikView refuses to open any file whose extension it does not recognise. Maybe using cmd command?

Thanks in advance

Alexis

Re: Data file renaming. How?

simondachstr — Wed, 27 Aug 2014 10:30:11 GMT

1. Create a bat file doing something like:

ren *.(current extension name) *.(extension you want)

2. Execute the bat file from the QV script:

EXECUTE batfilename.bat;

Re: Data file renaming. How?

MarcoWedel — Wed, 27 Aug 2014 10:34:20 GMT

test data

Re: Re: Data file renaming. How?

MarcoWedel — Wed, 27 Aug 2014 10:35:53 GMT

seems to work with crr extension out of the box:

table1:
LOAD DealerID,
    KPIYear,
    [KPI Description],
    KPI1,
    KPI2,
    KPI3
FROM
[http://community.qlik.com/servlet/JiveServlet/download/596334-122071/QlikCommunity_Thread_130945.drr]
(txt, utf8, embedded labels, delimiter is ',', msq);

hope this helps

regards

Marco

Re: Data file renaming. How?

ashfaq_haseeb — Wed, 27 Aug 2014 10:51:37 GMT

Hi,

While you select file --> from drop down select all files and select your.drr extension file.

It should work

Regards

ASHFAQ

Re: Data file renaming. How?

alexis — Wed, 27 Aug 2014 12:15:37 GMT

Hi Ashfaq,

I had assumed that because it was an unrecognised extension it would not read it but it seems it recognises it as a CSV file regardless. Thanks

Alexis