Hi Team,
I have a situation where we need to find the "Same Description" but different "ID" and
a) create a match score
b) and an indicator with "yes" or "No"
Please find below the dummy data,
Thanks
Sri
Id | description |
409106869 | 01Isolierstoffgehäuse 3RV1913-1CA00 |
409107095 | 04-2000-20-700 Steuerventil, P4/P8, PP |
409107095 | 04-2000-20-700 Steuerventil, P4/P8, PP |
409107099 | 08-1010-51 Membrane Neoprene, A/P/T/W8 |
409107099 | 08-1010-51 Membrane Neoprene, A/P/T/W8 |
409107099 | 08-1010-51 Membrane Neoprene, A/P/T/W8 |
409107099 | 08-1010-51 Membrane Neoprene, A/P/T/W8 |
400930564 | 140GETASTER, TYP XAC-FAS 3251 TE GE, MIT |
400930564 | 140GETASTER, TYP XAC-FAS 3251 TE GE, MIT |
400930564 | 140GETASTER, TYP XAC-FAS 3251 TE GE, MIT |
400931364 | 2/2-WEGEMAGNETVENTIL, |
400931364 | 2/2-WEGEMAGNETVENTIL, |
400931364 | 2/2-WEGEMAGNETVENTIL, |
400931364 | 2/2-WEGEMAGNETVENTIL, |
400931364 | 2/2-WEGEMAGNETVENTIL, |
400931364 | 2/2-WEGEMAGNETVENTIL, |
400931364 | 2/2-WEGEMAGNETVENTIL, |
400931364 | 2/2-WEGEMAGNETVENTIL, |
400931364 | 2/2-WEGEMAGNETVENTIL, |
400931511 | 2/2-WEGE-MAGNETVENTIL, TYP 40126, NW 40, |
400931511 | 2/2-WEGE-MAGNETVENTIL, TYP 40126, NW 40, |
400931511 | 2/2-WEGE-MAGNETVENTIL, TYP 40126, NW 40, |
400927713 | 2/2-WEGE-MAGNETVENTIL, TYP 5282 |
Hi Team,
Any thoughts on this please?
thanks
Sr
Hello @sriniprad08 ,
Fuzzy Matching is a good fit for your challenge:
https://www.youtube.com/watch?v=ZPQA-k3rJgQ
https://help.alteryx.com/current/designer/fuzzy-match-tool
Quite advanced though, you need to spend some time on learning + fine-tuning Fuzzy Matching.
Best regards
Phil
I guess this post is same as this one
Which has been solved😣