MergeJoin by record number

oldforum

• July 16, 2007 00:00

• Answered

Follow

What would be the best way to take two inputs whose records are related to each other by their location within the file? There are no common keys to join by.

• 

  oldforum

  • July 16, 2007 08:23

  0

  Comment actions Permalink

  So what about to create your own artificial key via reformat component? To each record in both input stream you can generate ordinal number and then join them with merge join component...
  
  Or consider creating a custom component, which should be very similar to reformat one.
  
  Don't hesitate and ask me for more details if it is necessary.
  
  OtaSanek
• 

  oldforum

  • July 16, 2007 08:23

  0

  Comment actions Permalink

  I have thought about a custom KeyGenerator component, and I can see how using a PrimitiveSequence within a Reformat component could accomplish it.
  
  However, I was hoping to eliminate the extra pass through each data set.

Please sign in to leave a comment.