I've to create a condition to check both C and D at the same time. Since my job is reading row by row, the condition for both C and D as Y is always false.
If your file is as small as shown on your example, you connect your tFileInputDelimited to a tSetGlobalVar ot tFlowToIterate component giving one global var per record where the name is based on the Filter filed value and the value is based on Flag field.
On subjob, you can compare the records value as desired using corresponding global var.
