Fuzzy Matching - Group By

[dhakim1996]

Hi so I have the following line items:

Account Code	Description	Accounting Period	Base Amount	Transaction Amount
123455678	Electricity Invoice April 23_lt. 12A-H	2023/001	3,120,148	3,120,148
123455678	Electricity Invoice April 23_lt. 12A-H	2023/001	28,364,985	28,364,985
123455678	Electricity Invoice April 23_lt. 15A-D	2023/001	1,352,450	1,352,450
123455678	Electricity Invoice April 23_lt. 15A-D	2023/002	12,295,001	12,295,001
123455678	Electricity Invoice April 23_lt. 15E-H	2023/002	1,617,651	1,617,651
123455678	Electricity Invoice April 23_lt. 15E-H	2023/003	14,705,919	14,705,919
123455678	Electricity Invoice April 23_lt. 16A-H	2023/004	5,102,853	5,102,853
123455678	Electricity Invoice April 23_lt. 16A-H	2023/005	46,389,572	46,389,572
123455678	Electricity Invoice April 23_lt. 17A-H	2023/006	3,524,304	3,524,304
123455678	Electricity Invoice April 23_lt. 17A-H	2023/008	32,039,128	32,039,128
123455678	Electricity Invoice April 23_lt. 2-35A	2023/008	2,354,959	2,354,959
123455678	Electricity Invoice April 23_lt. 2-35A	2023/009	21,408,721	21,408,721
123455678	Electricity Invoice April 23_lt. 2-35A Sign	2023/010	198,180	198,180
123455678	Electricity Invoice April 23_lt. 2-35A Sign	2023/012	21,800	21,800
123455678	SO ABC LED Repair and Replacement Installatio	2023/008	4,290,000	4,290,000
123455678	SO DEF LED Repair and Replacement Installatio	2023/008	471,900	471,900
123455678	SO GHI LED Repair and Replacement Installatio	2023/008	(4,290,000)	-
123455678	SO IJK LED Repair and Replacement Installatio	2023/008	(471,900)	-
123455678	SO ABC LED Repair and Replacement Material	2023/008	(8,765,000)	-
123455678	SO DEF LED Repair and Replacement Material	2023/008	(964,150)	-
123455678	SO GHI LED Repair and Replacement Material	2023/008	8,765,000	8,765,000
123455678	SO JKL LED Repair and Replacement Material	2023/008	964,150	964,150
123455678	Support unit	2023/008	350,000	350,000

Based on the above i want to group the line items that have similar descriptions together using fuzzy match and the output is that I want to group those similar line items together giving me one amount - for example combine all the electricity line invoices into one line item so that I know that how much is spent for electricity invoices altogether. 

Could someone assist with a workflow please? I have never used fuzzy matching before and somewhat unsure. 

Thank you in advance. 

[adamweaver39]

Hi @dhakim1996 , I tried to set up a fuzzy match flow, with limitred success -- I attempted to follow the flow from the "Make Group" tool examples. However, I found it relatively simple to group using the RegEx tool. Including both examples in the attached workflow. Hope this helps!