How to updated only the last row in the record??

[#1]

Dear All,

I got a table as attached, while converting the loaded excel file into QVD I want to load only >= the date exist in the excel.

please see the highlighted row in the excel.  jagan mohan

[jagan]

Hi,

Can you explain bit more about your requirement, I want to load only >= the date exist in the excel.  Can you explain with an example.

Regards,

Jagan.

[sushil353]

hi,

Check this out: http://community.qlik.com/docs/DOC-4597

HTH

Sushil

[jagan]

Hi,

Try like this

Temp:

LOAD

Date(Max(DATE)) AS MaxDate

FROM ExcelFile;

LET vMaxDate = Peek(MaxDate);

DROP TABLE Temp;

Data:

LOAD

*

FROM ExcelFile

WHERE DATE = '$(vMaxDate )';

Hope this helps you.

Regards,

Jagan.

[renjithpl]

May be like this ?/

Main:
LOAD Date(DATE, 'DD/MM/YYYY') as DATE,
Buyer, Company, Qty, Value
FROM

(ooxml, embedded labels, table is Sheet1, filters(
Remove(Row, Pos(Top, 2)),
Remove(Row, Pos(Top, 1))
));
inner join
load
(Max(Date(DATE, 'DD/MM/YYYY'))) as DATE Resident

Main;

[#6]

ANY ONE??????

[anbu1984]

Do you want to load only the row with maximum date into QVD?

[Anonymous]

Hi,

Please elaborate on your question.

As per your request 'I want to load only >= the date exist in the excel.'

They are no records after the line highlighted in excel file , so which data you want to load and save to QVD.

Regards

Neetha

[#9]

Thanks for replaying.

Dear neetha P, anbu cheliyan, jagan

well, let's say I made initial load and made the QVD.... So QVD will be having a max(date)

and am having an excel as source data where user update huge set of records every time

when I load the excel for next time I want to load only the records more than or equal to qvd max date from excel and write only that records into the qvd

rather than loading everything from excel and over writing the qvd.

I want this because since the data source is in excel I won't be know if any modifications went on excel

So I don't want past records to be change I want to change the record more than or equals to QVD max date.  is there any way of doing this?

[anbu1984]

Qvd: LOAD Date(Max(DATE)) AS MaxDate FROM Qvd(Qvd); 

LET vMaxDate = Peek('MaxDate',0,'Qvd');  

Data: LOAD * FROM ExcelFile WHERE DATE >= '$(vMaxDate)';

Concatenate

Load * From Qvd(Qvd) Where Not Exists(Buyer&Company,Buyer&Company);