Mapping Issue

[Former Member]

Hi Experts,

I am using FCC at both sides sender and receiver side. It's a Field fiexed lenght file as Source and target structure are same.

Noted: Y and N are the last fields of the flat files.

I have given below requirement in mapping:

If Source FiledName = 'N' then it should be Replace with sapce (' ')

If Source FiledName = 'Y' then Map as it is to Receiver Field.

I have applied the logic as suggested:

1) Compare the source field with a constant (N) and if true then map another constant ( ) ...i.e. space....to the target

2) Compare the source field with a constant (Y) and if true then map the source field itself to the target.

Use ifWithElse ....one input (then) will come from part1 and other input (else) will come from part2

I am not getting the desire output..

Sameer

[Former Member · Accepted solution]

Hi Khanna,

Take if else and for if compare it is N. For comparision you should take equals function in text. Then for true part give space and for else give input field.

Regards,

---Satish

[Former Member · Accepted solution]

Thanks a ton Satish..

I know it's simple logic but i did mistake in Equals function now done..

Closing the thread!