Hi,

I have 4 columns
Notional amt
Notional Currency
Sec notional amt
Sec notional Currency

My condition is like this
1.
if
Notional Currency equalto'USD'
then
Notional equalto Notional amt
and
Foreign equalto Sec notional amt

2.
if
Notional Currency notequalto 'USD'
then
Notional equalto Sec notional amt
and
Foreign equalto Notional amt

Please help me out on this issue

this isn't a very complicated condition if you take a minute to think through the logic:
NOTIONAL=IF NOTIONAL_CURRENCY EQ 'USD' THEN NOTIONAL_AMT ELSE SEC_NOTIONAL_AMT;

and

FOREIGN=IF NOTIONAL_CURRENCY EQ 'USD' THEN SEC_NOTIONAL_AMT ELSE NOTIONAL_AMT;

You can only define one field at a time - don't make it more complicated than it is.

It's pretty much the way you specified it:
DEFINE FILE filename
NOTATIONAL_AMT1/format=IF NOTATION_CURRENCY EQ 'USD' THEN NOTATIONAL_AMT ELSE SEC_NOTATIONAL_AMT;
FOREIGN/format = IF NOTATION_CURRENCY EQ 'USD' THEN SEC_NOTATION_AMT ELSE NOTATIONAL_AMT;
END
Of course, you have to put in the correct format, and use the fieldnames that correspond to your data, but hopefully this makes sense. The DEFINEs can also be in the master file Description. Please note: I used different names for my DEFINE fields than for the original fields. I always recommend that to avoid confusion.