Update, Append, Purge, Composite key

[userid128223]

I have following data that has source QVD and daily qvd. Source needs to get modified on daily basis via updates from daily.qvd.

• Uniq key is composed of:  EmpID+EmpName+CreateDate
• Daily file will have duplicate data where only updateDate will indicate latest recods which needs to be kept.
• Data that is similar in daily.qvd needs to be purged out based on latest Updatdate.

Daily.qvd

EmpID	EmpName	Amount	TerminalNo	CreateDate	UpdateDate
123	Joe	$200	20	1/6/2014	1/6/2014
123	Joe	$100,000	20	1/6/2014	1/7/2014
123	Joe	$500,000	20	1/6/2014	1/9/2014
123	Joe	$400	40	1/8/2014	1/8/2014
235	Doe	$55	20	1/8/2014	1/22/2014
235	Doe	$200,000	20	1/8/2014	2/1/2014
235	Doe	$500	50	1/15/2014	1/15/2014
345	Kim	$456	56	1/9/2014	1/9/2014
724	Mele	$25	20	1/18/2014	1/18/2014
887	Duwane	$15	30	1/22/2014	1/22/2014

Source.QVD

EmpID	EmpName	Amount	TerminalNo	CreateDate	UpdateDate
123	Joe	$200	20	1/6/2014	1/6/2014
123	Joe	$400	40	1/8/2014	1/8/2014
235	Doe	$55	20	1/8/2014	1/22/2014
235	Doe	$200,000	20	1/8/2014	2/1/2014
345	Kim	$456	56	1/9/2014	1/9/2014

FINAL RESULTS:

EmpID	EmpName	Amount	TerminalNo	CreateDate	UpdateDate
123	Joe	$500,000	20	1/6/2014	1/9/2014
123	Joe	$400	40	1/8/2014	1/8/2014
235	Doe	$200,000	20	1/8/2014	2/1/2014
345	Kim	$456	56	1/9/2014	1/9/2014
724	Mele	$25	20	1/18/2014	1/18/2014
887	Duwane	$15	30	1/22/2014	1/22/2014

[userid128223]

Daily updates are only for past 2 months of data  Hence master will eventually have much longer period of data then daily.