This content has been marked as final. Show 3 replies
I have a list of fields that I want to get dropped from the tables that get loaded in a loop.
FOR each tablename in $(varTableNames)
LOAD * ; select * from $(tablename);
DROP Fields $(varFieldNames);
The varFieldNames is a comma separated list of some random fields in the form of 'Table1.field1','Table2.field5' etc.. Now e.g. if the tablename is not the Table1 I get a pop-up with the error message "wrong field name in the drop fields statement" or something for the Table1.field1. It breaks the script execution.
Is there a way to suppress that behavior? I just want to ignore the those errors and let the script run through.