on 12-09-2008 10:19 PM
Hi,
In my requirement i want to generate a tab delimated file. So i used FCC in Reciever CC and am able to create a tab delimated file. But the file content is not in the format i am expecting. File created as shown below.
Eid First Name Middle Name Last name
7 raj reddy petter
8 ram johnson
Here 'Johnson' is last name of 'ram', But it displayed under the 'Middle name' column, as the employee does not have the middle name.
But i want file in the format shown below.
Eid First Name Middle Name Last name
7 raj reddy petter
8 ram johnson
Please suggest me what i need to do to generate the file in the required format.
Thanks in Advance..
Regards
Sreeni
You have to use 1..1 cardinality while creating your target data type and see to that in the mapping if the source side element is not present, even then you should create the target element. use Mapwithdefault for this function.
As long as your target message has the empty element, the file will generate properly.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
You can handle this in mapping. just pur a condition for all the fields(middle name, last name) if missing like
field---
equalS-----If then----Constant(Space)-----Target field ---else----Field-----Target Field.
Constant(blank)
Thanks!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
83 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.