Page 1 of 1

soundex on joining keys

Posted: Tue Nov 17, 2015 2:03 pm
by BSG1
Hi All,

I have one flat file with some name. I have data from some table. I need to join them using soundex function on name. How can I use Soundex function on joining keys?

Posted: Tue Nov 17, 2015 3:52 pm
by ray.wurlod
Generate the Soundex values in upstream Column Generator stages.

Re: soundex on joining keys

Posted: Wed Nov 18, 2015 12:50 am
by naveenkumar.ssn
Use the stage variable read it with soundex and compare it..

Not tested it though , it should work. Logically

Regards
Naveen

Posted: Wed Nov 18, 2015 8:08 am
by chulett
Not compare... join two Soundex values.