Mapping

[Former Member]

Hi All,

Can you suggest me how can i achive the following mapping requirement ?

scenarios is CSV to XML

Source file having the following data

1,XYZ,ABC

2,ABC,XYZ

3,DDD,EEE

1,Accounts,Manager

2,Sales,Manager

3,Production,Manager

Here initial 1,2,3 are considering as record numbers. now i want to merge the same record data into one record. from the above data i want to get the receiver structure as follows

<Row>

<name>XYZ</name>

<city>ABC</name>

<department>Accounts</department>

<designation>Manager</designation

</Row>

<Row>

<name>ABC</name>

<city>XYZ</name>

<department>Sales</department>

<designation>Manager</designation

</Row>

Thanks,

Satish

[Former Member]

Have a look at this blog to start with:

<a href="/people/shabarish.vijayakumar/blog/2006/02/27/content-conversion-the-key-field-problem Conversion ( The Key Field Problem )</a>

There are loads of other blogs and documentation to guide you. Have fun.

[santhosh_kumarv]

Hi anil,

I hope you are receiving these records in two diferent files.

U can use the correlations in the BPM to mergre these records.

Regards

San

[Former Member]

yes Santhosh i am receiving records from two files, yes it is possible with BPM but i dont want to go with BPM.

Thanks,

anil

[Former Member]

Hi

can you please explain that your requirment is to collect the data into one record depending upon the department of designataion.in both the case use the concept of key value and it would be solve.

Thanks

sudhir sharma