on 2010 Jul 23 3:53 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
66 | |
10 | |
10 | |
10 | |
10 | |
8 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.