Function Soundlike

4 posts / 0 new
Log in or register to post comments
Last post
Thu, 01/11/2018 - 10:46
#1
hamid's picture
hamid
Offline
Joined: 01/11/2018 - 10:37
Function Soundlike

Hi,
Pleas I need Help on one equation on Idea and this is my problem :
I got two files having column of the person’s name and I want to check with the function @SoundsLike the existing and no existing name on each file
How can I do this pleas

Top
Thu, 01/11/2018 - 11:12
Brian Element's picture
Brian Element
Offline
Joined: 07/11/2012 - 19:57

HI hamid and welcome to the site.

The function @SoundsLike works in the equation editor which means it can only work on record at the time.  From what you are saying you want to compare names between two files.  Which version of IDEA are you running?  If you have 10.1 (I think) or higher I can show you how to do this.  If you have version 10 can you check under Duplicate Key if you have an option for Fuzzy, if you do you are luck.

Let me know.

Thanks

Brian

Top
Sun, 01/14/2018 - 03:26
hamid's picture
hamid
Offline
Joined: 01/11/2018 - 10:37

Hello Brian,
Thank you for your response,
my Idea softare version is 10.2.1.56 (X86 ) 
thanks in advance

Top
Sun, 01/14/2018 - 07:03
Brian Element's picture
Brian Element
Offline
Joined: 07/11/2012 - 19:57

Hi Hamid,

I just remembered that CaseWare created a video on how to do this.  https://www.youtube.com/watch?v=Lu3mwVqE-G4&t=395s

What you do is you rename the fields you are looking for duplicates in to the same name and then you append the files together and do the fuzzy matching.

Let me know if it works for you.

Thanks

Brian

Top