How to flag out history records using load script Or expression ??

[#1]

Hi All ,

I need to perform a bit of history management with my member profile .

Here i am attaching data file . "Input" sheet contains data which i am recieving , while after loading script i need to store what mentioned in "Output" sheet into QVD file.

Can anybody advice me with load script ?

One more question can this be also taken care in chart - expression itself ,if Yes, then how ???

Looking for urgent help .

Regards,

Bhushan N

[#2]

based on what condition are you determining the status field? I don't see anything in the import file that gives any indication if something is updated.

Can you be more specific about your requirement? What are you actually trying to acomplish?

[#3]

Hi ,

Here i mainly want to focus on to maintain history in customer DB.

There are different business logic which works to determine level of a particular customer . So here i need to consider

1) Latest record of the customer which nothing but latest customer records datewise.

2) If customer exists in DB , then make previous record as "Modified" & make latest record as "Active".

Rgeards,

Bhushan N