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 |
Solved! Go to Solution.
Hi @sriniprad08
Here is a workflow for the task.
Output:
Workflow:
Hope this helps 🙂 Feel to ask if you have any questions
If this post helps you please mark it as solution. And give a like if you dont mind 😀👍
hi @atcodedog05
Thank you so much 🙂 . Does it test "Same description" but different "ID".?
Cheers,
Sri
Hi @sriniprad08
Yes thats right.
I used summarize because there were same ids repeated time multiple times. If you remove it it will compare one row with each other.
Hope this helps 🙂
Hi @atcodedog05
Thank you 🙂 . Is it possible to add an column called "indicator " with values "yes " if the "description is same but the "id" is different and "No" other way.
Thanks for the help
Cheers,
Sri
Hi @sriniprad08
Here is a workflow for the task.
Output:
Workflow:
Hope this helps 🙂 Feel to ask if you have any questions
If this post helps you please mark it as solution. And give a like if you dont mind 😀👍
Hi @atcodedog05
Thank you so much :). I will check with my data and let you know .
But it looks perfect.
Happy thanks giving,
Cheers,
Sri
Happy to help 🙂 @sriniprad08
Cheers and Happy Analyzing 😀
Feel free to reach out if you face any issues 🙂