I understand the point mentioned, But in my case i have situation where current file can have additional columns included or also have chance of missing columns. Either of the case I need to highlight to the end user that we are receiving additional columns and missed out few columns when compared with previously provided files.
To be more specific, attached is the sample application where in column @12 & @14 is newly added to latest file received when i compare with previously received file, Here my question how to handle this case.
Please review and let me know if you need any additional details
Yes, you are correct, just that basic rule is to highlight the missed or newly added column in latest file to the end user.
I have just seen the application and i came know that you need the latest and previous files info right !!!
Chetan - Yes your understanding is Correct
And you want to see the file and its latest time
Chetan - I need to see File metadata, and latest time i have used for finding the file in the previous folder.
if there any changes made to that particular field in a file should be notified as a highlighted.
Chetan - Not exactly changes, I assume that u understood @14 field 'Address" has become as "Rank_Address", if yes then the understanding is wrong bcoz for me "Rank_Address" are new column added to my file which was not in previously received file. Also vise versa also should work, If current/latest received file missing column when compared to previously received file then again i need to highlight
Hoping we are on same page.
I cant stop from thanking you, as you have understood and explained me details at the best. Thanks once again.