Re: We need to show only updated and new records in separate table
Your output is exactly same as Table2. Do you have this new data coming from separate file, you could directly use that instead of merging it with existing data and then extracting new and updated one.
//returns the value of MaxId from the first last record read into the current internal table. But, Here you are calculating Max(ID) only. How this identify to show DROPTable A; NewProd: LOADID, Name, Location, Sales, [Posting Date