Skip to main content
Announcements
Save $600 on Qlik Connect registration! Sign up by Dec. 6 to get an extra $100 off with code CYBERSAVE: REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
vishalgoud
Creator III
Creator III

How to rename the files which are generated in Export option in Qlikview..?

Hi All, 

we are generating the text files using the export option in Qlikview, After generating the excels file names are like ABC.text and we want them to be like YYYYMMDDABC.txt.

can any one please guide me the better way to do, is there any macro which can run post reload and serve the purpose. 

if not macro came to know that using batch files as well we can achieve this.

@Peter_Cammaert  @sunny_talwar  @jagan  @Anil_Babu_Samineni can any one of you  look into this please. 

Thanks Much in advance. 

BR,

V

 

 

Labels (1)
1 Solution

Accepted Solutions
Brett_Bleess
Former Employee
Former Employee

Only thing that comes to mind would be to run a PowerShell script post export that would do the renaming for you, you can can call the script from the QlikView script using CMD.exe /c etc.  That is about the only means of which I see to do this.  The only other thing would be to submit an idea in Community to allow renaming, but it did just occur to me that you should be getting dialog to do this:

https://help.qlik.com/en-US/qlikview/April2020/Subsystems/Client/Content/QV_QlikView/Export.htm

You appear to have left out some details that are pertinent, please leave further clarification, but I would recommend reviewing Help content on what you are trying to do in order to be sure you are seeing expected behavior according to the documentation.

Regards,
Brett

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.

View solution in original post

1 Reply
Brett_Bleess
Former Employee
Former Employee

Only thing that comes to mind would be to run a PowerShell script post export that would do the renaming for you, you can can call the script from the QlikView script using CMD.exe /c etc.  That is about the only means of which I see to do this.  The only other thing would be to submit an idea in Community to allow renaming, but it did just occur to me that you should be getting dialog to do this:

https://help.qlik.com/en-US/qlikview/April2020/Subsystems/Client/Content/QV_QlikView/Export.htm

You appear to have left out some details that are pertinent, please leave further clarification, but I would recommend reviewing Help content on what you are trying to do in order to be sure you are seeing expected behavior according to the documentation.

Regards,
Brett

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.