Consolidation - Load Script.??

[tamilarasu]

I have a file which has many customers and we have to send this to sales representative every month. Due to large lines they work for few customers and forward the file to us in many split ups. If they are not able work for any customer, they used to mark it as delete in the status column and mark it as (ZF/ZD/Delete) for the customers they worked. I want to consolidate these files, so that I can process further in QV. I am not sure how to do this in load script.

Say for example, I have two customers 1 and 2 in a file. First, they worked for customer 1 and send the file to us. They have changed customer 2 status to delete for identification (will be send in next split). We got another file after one week and this time worked for customer 2. As I said. status for customer 1 is now deleted. I want to consolidate the files to single file like below.

Any idea?

Attached sample file,

in advance.

[ramoncova06 · Accepted solution]

I believe that assigning a value to the status and then getting the max value should work for this

attached file with you sample data