The syntax for the following where clause is correct, the script runs without error, but the expected result is incorrect as if it ignored the where conditions. I'm expecting to see only records where Entity Status2='A', Studflag='STUD' AND Profession = 'NUR' AND Yrsins2=1. The output includes all records. I've attached the qvw document, but the data is too large to attach.
T1_ActiveTerm3: LOAD * Resident T1_ActiveTerm2 WHERE ([Entity Status2] = 'A' AND Studflag='STUD' AND Profession = 'NUR' AND Yrsins2=1);
You don't need two. But your modification specifically list fields. That list of fields is a subset of all the fields that exists in T1_ActiveTerm2. Since that will create a table with a different structure (less fields than the source table) the records will end up in the new table instead of being appended to the source table.