Transforming data problem

CloverDX Platform
1

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

2

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.

3

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