It sounds like your third field should be a calculated field using the IF() function in some way.
I will take a guess that in your two field example only one of the fields is populated - sex will be either male or female. So a calculated field might be something like this:
IF(MALE_FIELD<> " ", "M","F")
However you may need to cover for the possibility that the FEMALE sourced field is also blank OR populated which makes things a little more interesting and would require a nested IF()formula or a series of IF() comparisons.
I hpoe this helps. Please let us know if the data presents the need for a more complex solution.
Thank you very much for the quick response.
I've tried this logic and it is working fine when I compare only two fields. As I mentioned in my earlier mail, I actually needs to compare with two or more fields. In one such instance, I need to compare 8 different fields.
Please give me more insights on using the NESTED loop or any other logics.
Thanks and Regards