Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

Data loading error while connecting my csv file to the QVF file.

I am preparing a report on weekly basis in Qlick sense. My QVF file for last week report file is saved in Qlick>Apps> qvf  and my new csv file is in my download folder. While connecting my csv file to the already prepared QVF file through add my data option > connect my data > delimited file > path , the elapsed time window showing an error .. Data loading error. Go to the data loading editor and edit the script.

Can some one please help me on this on urgent basis.. Thanks in advance.

8 Replies
datalakeyu
Valued Contributor

Re: Data loading error while connecting my csv file to the QVF file.

Try to put your csv and qvf files at the same folder.

Not applicable

Re: Data loading error while connecting my csv file to the QVF file.

Script error.PNG

Please help me on the above error while connecting a csv with my qvf file.

phaneendra_kunc
Valued Contributor III

Re: Data loading error while connecting my csv file to the QVF file.

Error is not descriptive enough. Did filename/sheet name of excel changed?

Not applicable

Re: Data loading error while connecting my csv file to the QVF file.

Can you please elaborate on the issue. I haven't changed any file name or sheet.

If you want I can paste the full script.

phaneendra_kunc
Valued Contributor III

Re: Data loading error while connecting my csv file to the QVF file.

Looks like file doesn't exist in the location "Alteryx Inputs" folder.

Try going to edit script and click on "Alteryx Inputs" data connection and see if you can find your excel file.

Not applicable

Re: Data loading error while connecting my csv file to the QVF file.

Actually "Alteryx Inputs" folder is unable to create inside library as such. It requires one more folder ( eg: Documents or Pictures.). Thus i tried to create a folder named 'Alteryx Inputs ' inside my lib>document folder and saved the file and re write the script and run . Still the error persists.


Please help me for a way out for this error.

Not applicable

Re: Data loading error while connecting my csv file to the QVF file.

Is it really required to have all supporting file for QVF file in our system once the  file is created.

I got one QVF file from my client for report hand over and every week I am getting new week csv file for connecting to my QVF file shared. In this case the data loading error is happening asit says old file paths for QVF are not available.

Please throw some light on this issue.

phaneendra_kunc
Valued Contributor III

Re: Data loading error while connecting my csv file to the QVF file.

So every week if the file name changes then YES, you have to rename the file name or needs to change the script in QVF. I would suggest to use a generic file name so that it load properly.

Remember to keep the names consistent every week. 

1. Folder Location

2. Excel/Csv File name

3. Format of excel/csv. If is .CSV then maintain as .CSV

4. Field Names in Excel/CSV

5. Sheet Name in Excel/CSV

There are other ways to read data even above changes, but it requires in creating some complex queries.

Community Browser