Does the new source has the same column names as the revoked excel source?? If they are you can replace the old one with the new one and nothing in your application should break. I recommend making a copy of your application and then trying with the new source, so that in case something break you will have a back copy to go to.
If you do a reload from this new source file, you will lose the data that was loaded from the database (unless you saved that in a QVD - or other file form). I am assuming that you want to keep the data as you can no longer retrieve it from the database.
What I would suggest is that you create a copy of the qvw file. In the new copy, clear out the load script and start a new script with a binary load of the first document. Then, either:
- save the relevant data to a QVD file, which you can then use as a data source in place of the database.
- or, use that as the start of a longer script that adds the data from the new source through concatenation and/or joining) to the tables you binary loaded.
Hi, what jonathan mentioned should work.
You can take a binary load of your previous document in a new QVW and store the data base tables into QVD's.
You can then use these QVD's anywhere.
Binary [..\documents\ankit\qw\test\new qlikview document (2).qvw];
SET TimeFormat='h:mm:ss TT';
SET TimestampFormat='M/D/YYYY h:mm:ss[.fff] TT';
Store tablename into tablename.qvd(qvd);