Hi All.   I have a master table with a column string as shown below : STRING 49 Laurel Court Mount Vernon NY 10550 9925 W. Greystone Lane Hamdn, CT 06514,HMn 83 South Aldeood Street Middletown, CT 06457 518 Goldfield Drive Bakersfield, CA 93306 8991 Fairground Lane Nutley, NJ 07110 63 Bay Court Elkridge, MD 21075 83 South Alderwood Street Midletown, CT 06457 Bakersfield 8991 Fairground Lane Nutley, NJ 07110 W. Graystoe Lane     Now There is another table which contain lookup values . I need to use the lookup values to find the probable matches in the string column of master table.   LOOKUP VALUES Hamden Middletown Nutley W. Graystone Lane South Alderwood Street   So , I need my final table as below STRING Probable1 Probable2 49 Laurel Court Mount Vernon NY 10550     9925 W. Greystone Lane Hamdn, CT 06514,HMn HAMDEN   83 South Aldeood Street Middletown, CT 06457 Middletown   518 Goldfield Drive Bakersfield, CA 93306     8991 Fairground Lane Nutley, NJ 07110 Nutley   63 Bay Court Elkridge, MD 21075     83 South Alderwood Street Midletown, CT 06457 Bakersfield Middletown South Alderwood Street 8991 Fairground Lane Nutley, NJ 07110 W. Graystoe Lane Nutley W. Graystone Lane So we have hamden in lookup table available and the most near match can be hamdn in 2nd record so I poulate  Hamden in Probable1 column for the record.   Like wise in the last record I can see Nutley as well as W. Graystone Lane having aprobable match in it so I need to populate Nutley in probable1 and W. Graystone Lane(not exact match) in probable2 column.   I can do if there is a direct match in the string column but in case of variations things do not workout as expected. So basically I also need to pull the lookup value if a variation of that is available in string column .   Any help on above will be highly appreciated.   Regards,                           ... View more

Hi All, i have four datasets as follows data one col1 cls_id 1 a 2 c 3 a data two col1 cls_id 1 d 6 e 8 d data three col1 cls_id 7 h 9 f 8 h data four col1 cls_id 10 m 5 l 9 m Now from these tables i need to create a final table so that each common element from these tables have a common cls_id and all associated elements to that common element in different table also do have same common cls_id. * FYI Actually i was running optnet to link elements but because of data size i am not able to run in a single go. Hence,I had to split the data and run optnet and try to merge these four tables . In table one and two element 1 is common and 8 is a associated element further 8 is also present in table 3 with 7 attached to it. hence 1,3,7,8 should share same cluster id similarly 9 and 10 should have same id Any help would be greatly appreciated. Regards         ... View more

Hi all, I have two tables as follows: Table A City                                    ZIP Code(s) Alabama (AL)Huntsville       35801 Alaska (AK)Anchorage        99501 Arizona (AZ)Phoenix           85001 Arkansas (AR)Little Rock   72201 California (CA)Sacramento 94203 Los Angeles                        90001 Beverly Hills                        90209 Colorado (CO)Denver        80201 Conneticut (CT)Hartford    06101 Deleware (DE)Dover         19901 District of Columbia           20001 Table B Zip      subcity 35801 alabama 35801 albama 35801 alabam 35801 hills1 35801 hills2 67980 hills3 67980 hills 67980 hills 90001 los 90001 albama 90001 rtff 80076 hartford 85001 Arizona 39801 alabama I need to extract subcity from city of table A using look up within zip. so that final output would be something like this City                                          ZIP Code(s)     ZIP        SUBcity Alabama (AL)Huntsville               35801        35801      alabama Alaska (AK)Anchorage                 99501 Arizona (AZ)Phoenix                    85001       85001      Arizona Arkansas (AR)Little Rock             72201 California (CA)Sacrament            94203 Los Angeles                                 90001       90001      los Beverly Hills                                90209 Colorado (CO)Denver                80201 Conneticut (CT)Hartford             06101 Deleware (DE)Dover 19901 District of Columbia 20001 I have used left join using where condition of zip=ZIP Code(s) AND CITY CONTAINS SUBCITY BUT EXECUTION TIME IS VERY SLOW. Is there any way to achieve result more efficiently?   Also,can we use a fuzzy search so that we have result like this as well City                            ZIP Code(s) ZIP    SUBcity Alabama (AL)Huntsville 35801     35801 alabama Alabama (AL)Huntsville 35801     35801 albama Alabama (AL)Huntsville 35801     35801 alabam     Thanks a lot !!!!!!!!!   ... View more

Hi all,   In the below dataset I have 2 columns c and y with data as follows: X 34  45 th avenue South west 34 street   Column y  th avenue street   So using column y I need to look in column x and if the 1stword is th in y and pattern matches in xthen I need to pull  The preceding digit  So my final output z would be something like this.   Column y  45 th avenue street   Regards, Rohit     ... View more