How to join source files with no direct keys?

CloverDX Platform
1

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

2

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.

3

Thanks once again, Agata :slight_smile:

I’ll give it a try…

al