Transforming data problem

saravanan77

• September 07, 2007 00:00

• Answered

Follow

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

• 

  avackova

  • September 10, 2007 09:40

  0

  Comment actions Permalink

  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.
• 

  srinu

  • September 18, 2007 05:49

  0

  Comment actions Permalink

  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

Please sign in to leave a comment.