Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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