6 Replies Latest reply: Sep 2, 2016 7:53 AM by Jo Tedesco RSS

    List comparison - what is wrong with my concatenate syntax?

    Jo Tedesco

      Hi folks

      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

      Jo