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

    List comparison - what is wrong with my concatenate syntax?

    Josephinet 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