Hi,

I'm extremely sorry for the late reply. Thanks for looking at my post.

File formats are same except the file names are different based on date of the file arrival....

Thanks for your inputs DouglasH.

1.I chose this approach as I'm good with excel and it was easy for me to create the data I needed in a table and...

Thanks douglasH. I knew it would be a simple fix and I was close to getting the code work.

Do you have any ideas to update view definition(table names in...

Yes drew.allen. I also considered the scenario where customer started with one emailaddress and changed to couple more different emailaddreses and changed back to same emailaddress he/she started with. In...

Thank you GSquared. I really appreciate your help on this. I'll see if i can implement this with real data.