How to join source files with no direct keys?

achan

• March 28, 2008 00:00

• Answered

Follow

Hi,

I have source file A with all String fields, named colA1 and colA2. I have another source file B with all String fields, named colB1 and colB2. To link the 2 source files, this is the joinKey:

colA1 = "RHS" + colB1

which means during the link process, the string "RHS" has to be added to colB1's data in order to link to colA1's data, using MERGE_JOIN.

How can I do this link? Keep in mind that I must not change the data in colB1 permanently, which means that after linking, the output data should have the original data from colA1 and colB1, but not "RHS" added to colB1's data...

Thanks,
al

• 

  avackova

  • March 31, 2008 08:15

  0

  Comment actions Permalink

  Hi,
  it is not possible to do in one step. Before MergeJoin you have to put Reformat with direct mapping of colB1 and colB2 and with one more column colB3="RHS"+colB1, and then use this column as merge key.
• 

  achan

  • March 31, 2008 16:17

  0

  Comment actions Permalink

  Thanks once again, Agata :-)
  
  I'll give it a try...
  
  al

Please sign in to leave a comment.