topic Get info from two separate Excel sheets for different dates !!! in QlikView

Get info from two separate Excel sheets for different dates !!!

Wed, 28 Sep 2011 18:03:19 GMT

Hello all,

I have a doubt and i have an idea how to solve it but no idea how to translate it into script language.

I have a QV report that besides fetching info from tables in Movex, also gets some basic info from an Excel file.

Anyway i wish that from a certain date onward, the report gets the basic info from a new Excel file, without erasing what was scripted till that date.

By this i mean:

Before date x , the report uses Excel file A . After date x then report should use Excel file B.

Is there a way of placing a "if" clause on the script that can be used to solve this issue ?

Thanks a lot in advance for helping me !!!

Get info from two separate Excel sheets for different dates !!!

Wed, 28 Sep 2011 19:15:57 GMT

try something like this:

Table:

LOAD Date,

Value

FROM

[Book1.xlsx]

(ooxml, embedded labels, table is Sheet3)

Where [Date] >= '01/04/2011'

;

Table:

LOAD Date,

Value

FROM

[Book2.xlsx]

(ooxml, embedded labels, table is Sheet3)

Where [Date] < '01/04/2011'

;

Get info from two separate Excel sheets for different dates !!!

Thu, 29 Sep 2011 13:53:37 GMT

That is not quite what i intend. Maybe i did not explain myself very well.

Lets suppose that we have a script that is generating data using a table from Excel file A. Then from date x onward i intend to have the script to create data based on Excel file B but what was generated till date x with Excel file A i do not wanna change. I simply want to add to the data generated from Excel file A, what is now generated with Excel file B. 🙂

I am thinkink about storing what was generated with Excel file A in a qvd file. Then i would in a separate script generate info from Excel file B and then (since the name of the fields will not change), load the qvd and join both tables ! Would it work? Thing is that i do not know how to do it 🙂 !