Hi

I am having two tables :

Table 1

ID NAME S-CODE

10 XYZ 1

20 ABC 2



Table 2:

ID TEST INDICATOR

10 QA N

10 BP Y

20 SC N

20 UT Y

I am using a merge transformation and loading the data in the flat file.

The final file looks exacltly what i was looking for (i am sorting on id before merge)

10 XYZ 1

10 QA N

10 BP Y

20 ABC 2

20 SC N

20 UT Y

But now i have a requirement to create flat file. When the S-code is 1, then from the Table 2, only those records should be loaded in the destination which has Indicator = 'Y'. So i am expecting the file should look like:

10 XYZ 1

10 BP Y

20 ABC 2

20 SC N

20 UT Y

So the record (10 QA N) should not be loaded because it has corresponding 'N' in INDICATOR column in table 2.

Please suggest how to proceed to create such a file with above mentioned requirement.

Thanks