Problem with script sintaxis

[#1]

Hi,

I can't understand why this simple script doesn´t create the table 'NEGOCIADAS' and then drop the table 'A'.

When the script arrive to 'NEGOCIADAS' instead of creating a new table with the rows according to its where condition, it seems keeping loading 'A' and finally drop  'A'

What is syntactically wrong with 'NEGOCIADAS'?

Thanks

[Gysbert_Wassenaar · Accepted solution]

Because it loads exactly the same fields it gets appended to table A instead of in a separate table. You need to add noconcatenate to the load statement for NEGOCIADAS.