# Transforming data problem

**URL:** <https://forum.cloverdx.com/t/transforming-data-problem/219>\
**Category:** CloverDX Platform\
**Created:** [September 7, 2007, 12:00am UTC](https://forum.cloverdx.com/t/transforming-data-problem/219 "2007-09-07T00:00:00Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![saravanan77](https://avatars.discourse-cdn.com/v4/letter/s/13edae/32.png) [@saravanan77](https://forum.cloverdx.com/u/saravanan77)\
**Post date:** [September 7, 2007, 12:00am UTC](https://forum.cloverdx.com/t/transforming-data-problem/219/1 "2007-09-07T00:00:00Z")

</div>

Hi,

In my graph i have 2 input source, one is FileReader and one is DBReader. Consider input file for the filereader is a file which has 5 rows.

For Example:  
Row1  
Row2  
Row3  
Row4  
Row5

Its out port metadata is also one field say (Field1).

For DBReader, it will return one value (say Key). Its outport metadata is also one field say Field2.

I need to merge these two output and should have metadata as Field1 & Field2. That is same key should be there for every row.

Regards,  
Saravanan A

---

<div class="post-metadata">

**Author:** ![avackova](https://avatars.discourse-cdn.com/v4/letter/a/65b543/32.png) [@avackova](https://forum.cloverdx.com/u/avackova)\
**Post date:** [September 10, 2007, 9:40am UTC](https://forum.cloverdx.com/t/transforming-data-problem/219/2 "2007-09-10T09:40:10Z")

</div>

I don’t exactly understand what you want to do, but I think you need MergeJoin or HashJoin component with simple transformation like this:  
${out.0.Field1} = ${in.0.Field1};  
${out.0.Field2} = ${in.1.Field1};  
you can use left outer join or full outer join option too.

---

<div class="post-metadata">

**Author:** ![srinu](https://avatars.discourse-cdn.com/v4/letter/s/f475e1/32.png) [@srinu](https://forum.cloverdx.com/u/srinu)\
**Post date:** [September 18, 2007, 5:49am UTC](https://forum.cloverdx.com/t/transforming-data-problem/219/3 "2007-09-18T05:49:35Z")

</div>

HI sarvanan,

use reformat transformer and map the input fields to the neccesary output fileds and then run the graph . it will work

regards  
srinivas  
[muddureddycnu@gmail.com](mailto:muddureddycnu@gmail.com)