.
glancing at the transaction dataset, I have an impression that case-insensitive matching based on comparison with more patterns — ILIKE ANY might bring a more accurate result. For example, Walmart could be displayed as ‘WAL-MART’, ‘Walmart.com’, ‘Wal [xxxxx] mart’ in the column. Step 3 The truth is