Not sure but if all of your fields are in single table it would be much easier.
You can do preceding load with in the table to create a new field as below
if(Datefield>= 'xx / xx / xxxx' and IDOperation='A number','YES','NO') as OperationFlag;
Field5 and so on....
Please check the syntax for above if condition.
Hope that works?