Macthing

[Borisham]

Hello

I have 2 csv files,
one with id and multiple color names for each id
and another one with color names that do not look quite the same to the color name in the first file (fuzzy lookup case).

I need to have on the file 2 for each color name the the most fit id rely on the name closest to it from file 1.

Thanks for your help

[mceleavey]

Hi @Borisham ,

can you provide some data so we can help you?

M.

[Borisham]

file 1

color_name	id
sky sea	6601
sky blue	6602
red bag	6608

file 2

booking_id	color name
22	Sky sea blue
11	sky blue
33	red bag-tool
44	red bag

Would like to achive :

booking_id	color name
22	Sky sea blue	6601
11	sky blue	6602
33	red bag-tool	6608
44	red bag	6608

[vizAlter]

Hi @Borisham — Try this solution:

[grazitti_sapna]

Hi @Borisham , you can simply use find and replace tool.

Thanks.

[atcodedog05]

Hi @Borisham 

Your previous scenario varies is much more complex then this one.

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/matching-by-sting/m-p/656991#M151919

We had to find the common color it wasnt given.

Has the requirement changed now? or is this different.

[Borisham]

@grazitti_sapna @vizAlter thanks guys, this is good but it gives value only for accurate value that exist in the id file.

For all the other cases(in between cases it will not show them any id's because the looks slitlig diffrent in the name).

How can I make it a bit better ?

Need to use another formula ? or change a bit the id file ?

@atcodedog05Yes, it's a diffrent case for the same solution. I have 2 cases to solve.

Thanks

[grazitti_sapna]

@Borisham ,Is it possible for you to provide a sample input and expected output for better clarification?

Thanks.

[Borisham]

@grazitti_sapna 

file 1

id	name
5501	Blue sky LTD
5502	Red sky
5502	red sky sand
5502	red & sand

file 2

name
Blue sky
Red sky & sand

output would like to achive

name	id
Blue sky	5501
Red sky & sand	5502

[grazitti_sapna]

Hi @Borisham , in this case you can go with fuzzy match tool, you might need to change the configurations as per the records. Due to lack of records I could only test on the set you provided and it worked. Please refer to the screenshot attached and the workflow.

I hope it helps.

Thanks.