List comparison - what is wrong with my concatenate syntax?

[josephinetedesc]

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

[ToniKautto]

What is your question?

If you have problems with a script, I would suggest that you add the script and elaborate what the expected output is.

[josephinetedesc]

the script is in the excel file???  Sorry I must have not added it.  Will check

Jo

[Anil_Babu_Samineni]

I suggest to create the resident load with the flag value and then try

[josephinetedesc]

Anil could you look at my script and tell me where to the resident load please?

Jo

[Peter_Cammaert · Accepted solution]

To the LOAD at the top, add a new column creation line like this:

Table:

LOAD 'Table1ACHS' AS TableName,

     rowCount,

     :

To the CONCATENATE LOAD underneath the first LOAD, do the same with another table name like this:

CONCATENATE

LOAD 'Table2SQL' AS TableName,

     URNumber,

     :

That should do it.

Peter

[josephinetedesc]

Thank you very much Peter - exactly what I need - I knew I was doing something wrong!