Data file renaming. How?

[alexis]

Hi

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

[simondachstr]

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;

[MarcoWedel]

test data

[MarcoWedel]

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

[ashfaq_haseeb · Accepted solution]

Hi,

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

It should work

Regards

ASHFAQ

[alexis]

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