This content has been marked as final. Show 6 replies
I thought i understood the syntax I copied from John Witherspoon's script on how to compare 2 lists.
I then massaged it and it works - brilliantly making file comparison so much easier that going to excel to check!
BUT I cannot get the tables names right. This would be an added feature - I can live without it but I really like the elegance of knowing which Table the fields originally came from.
John Witherspoon uses an inline script to get the information - I use an excel file but I think the problem is in the concatenate syntax.
I have included an excel file to show the comparisons i made.
Thank you for your help