Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I am trying to do incremental load with the following script. But gives the error message saying that "Field not found - <MaxYear>". As per me everything looks to be correct only. Can some please tell me whats wrong with this script.
ExistingTable:
LOAD Field1
,Field2
,Year
Month
..\App\Existing.qvd (qvd);Temp:
Load Max(Year) AS MaxYear,Max(Month) AS MaxMonth Resident ExistingTable;
Concatenate(ExistingTable)
LOAD Field1
,Field2
,Year
,Month
FROM
..\App\Data.xls
(ooxml, embedded labels, table is Sheet1)
Where Year > $(vMaxYear)
Where Month > $(vMaxMonth);
Thanks
Attitude
Hi Koushik
Still I am little confused! Because any way "Temp" table will return only one row then what is the use Peek function to return the particular value from the first row? Why can't we use something like below?
vMaxYear = MaxYear
vMaxMonth = MaxMonth
vMaxYearMonth = MaxYearMonth
Please explain it for my better understanding!
Thanks
Attitude
Hi,
Actually you need to tell qlikview that which value you want and from which field of which table.
You tried doing what you said, and you didnt succeed, try using peek. It will solve your problem.
Regards,
Kaushik Solanki