These kind of problems can be avoided slightly if you put a QVD layer in your application design right up front. The theory is that you can then swap out any given QVD with a QVD of data derived from a different source.
What you can do now is to create QVDs from BW that mimic the Excel sheets you already have. Swapping over in the application is then quite straight forward.
I've written a number of blog posts on data modelling and how to get your application design right. This one may be useful regarding moving to QVDs:
Yes i have been doing 24 qvds. Is there any way i can joing 6 qvds into one big qvd.
And how can i call 2 or more qvds in an other qvw. I heard by using binary only one qvw we can load,.
And also, i have some excel sheets for last 2 years(24 months) having the same column names, whilst creating qvds i am concatenating all the 24 files as advised in the community but its a long page load script , is there any way we can shorten that , i come across for each loop but not sure as i am novice to qlikview in writing the script .I need your help in this matter.
Please check in data source i.e excel that your date field in which form then read it in qlikview using date # function and then convert it into any format in which you want
suppose in your excel its in DD/MMM/YYYY i.e 17/Oct/2014 format.
So while loading table in qlikview
then
load
Date(Date#(DateField,'DD/MMM/YYYY'),'DD-MM-YYYY') as Date
Your options for joining data are CONCATENATE and JOIN. It sounds like for what you are doing - bringing data from different periods - that the concatenate option is definitely best. Binary loads are probably not something you want to be looking at here.
You certainly can enumerate around a folder of similar files to bring them all in. Take a look at this post on the subject:
I have a field called 'Paid in' which stores value 'September' in excel and now i am bringing that field into qlikview and I would like to use makedate function ,My previous developer used the function like this but
its not showing any result and I need to know what it is trying to do .
Date#(date(Makedate(num(Year),[GS3 Paid in],1))) as OBJ_GSoS_EndDate,
Can any one help me out this , How can I make it work.
Apologies, I presumed from your code that Year was one of the fields in your database. If you don't have the year and you just want to default to the current year you could put this:
