Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Using QlikView 11 Personal Edition, I am trying to build a demonstration prototype involving multiple [8] disparate source files. As a rookie, I am finding stuff out as I go along and cannot get it all done without adjusting keys, fields, and other "source-related" information. Hence, I have been incrementally trying to add new sources and establishing linkages as the concepts become clearer. As the process requires me to add/maintain the Script, I consequently have had to "re-load" the Script several times. This seems to work just fine when only or two one data sources are involved.
What I cannot seem to clarify are the "Rules" around the re-load function. After developing a script two days ago that worked just fine, I went back to it and tried to "add" a new data source. I am now getting the Script Error Message regarding the two previous and existing data sources as follows:
Cannot open file 'E:\ABCSourceData\ClaimDetRecords' The system cannot find the file specified.
followed by:
Cannot open file 'E:\ABCSourceData\ClaimHdrRecords' The system cannot find the file specified.
So it seems, that my incremental approach to prototype development is "doomed" inasmuch as I cannot seem to add new data sources without getting the messages as displayed above. What I would like to know is the following:
I am very impressed with the product so far but need to demo it beyond a simple script. I would really appreciate any feedback that the Community can provide.
Thanks very much
don't think there is a limited number of reloads
see here for more detailed info
does the file exists? ClaimDetRecords, without any extension?
Hi David,
The only restriction on the personal addition is in sharing the files. If you are getting the script error it is because there is an issue with the script. Can you post the load for that part od the script
Bill
Can you browse the folder E:\ABCSourceData and an you see the file there?
Are the file names correct including extensions?
Hi Massimo:
Thanks for your comments. I did rename the source files for some reason but had of course 'forgotten'. But strangely enough, when I changed the Script to match the 'changed' source file names, I am still getting the same message. If it helps at all, the input source files were comma-delimited but I had not changed the extension to a .csv when I had originally created and saved the files. Is it considered good form to have the .csv extension as opposed to just leaving the original .txt implied?
Hi Bill:
Thanks for your comments. I did rename the source files for some reason but had of course 'forgotten'. But strangely enough, when I changed the Script to match the 'changed' source file names, I am still getting the same message. If it helps at all, the input source files were comma-delimited but I had not changed the extension to a .csv when I had originally created and saved the files. Is it considered good form to have the .csv extension as opposed to just leaving the original .txt implied?
Hello Colin:
Thanks for your comments. I did rename the source files for some reason but had of course 'forgotten'. But strangely enough, when I changed the Script to match the 'changed' source file names, I am still getting the same message. If it helps at all, the input source files were comma-delimited but I had not changed the extension to a .csv when I had originally created and saved the files. Is it considered good form to have the .csv extension as opposed to just leaving the original .txt implied?
Hi David,
If you are using CVS file try tab delimited.
Bill
Your load script for a csv file should have details of any labels, the delimiter and other parameters, such as the example below
MyData:
load * from csv_file.csv
(txt, codepage is 1252, embedded labels, delimiter is ',', msq);