topic Re: File not found error, Cannot open file in QlikView

File not found error, Cannot open file

yrstruly — Sat, 16 Nov 2024 19:35:52 GMT

Hi, can anybody assistme Please? I am trying to export/store the main table to an excel/csv file, but i'm getting this error.

The code i'm running is "STORE [MainData] into
'C:\Users\Anthony\Documents\AIRLINE_MAIN_DATA.csv'
"

Re: File not found error, Cannot open file

Anil_Babu_Samineni — Sun, 24 Nov 2019 13:08:02 GMT

For me this sounds as there is another error. Can you go to the folder path and see If CSV file generated or not?

Re: File not found error, Cannot open file

yrstruly — Sun, 24 Nov 2019 13:21:26 GMT

The file you want to save your data must be created manually. I did so by creating a txt, csv and excel file. All three of them gives this error.

Re: File not found error, Cannot open file

salted — Mon, 25 Nov 2019 06:51:03 GMT

HI,

try the following code

STORE [MainData] into
'C:\Users\Anthony\Documents\AIRLINE_MAIN_DATA.csv (txt);

Re: File not found error, Cannot open file

Brett_Bleess — Mon, 09 Dec 2019 15:57:17 GMT

I believe Salted's post is likely on the right track per the Help:

https://help.qlik.com/en-US/qlikview/April2019/Subsystems/Client/Content/QV_QlikView/Scripting/ScriptRegularStatements/Store.htm

If that did work for you, be sure to use the Accept as Solution button on their post to give them credit for the assistance and let other Community Members know that is what was missing. If you are still working on things, leave an update for us.

Regards,
Brett