How to count in 2 xls file and shows differences

Questions
1

Describe the problem/error/question

Hi, i have two reports from 2 diffrent app’s and need to see where are differences. The main problem is thath in report 1 services have name from medical app and from report 2 have names from users describe - final thath services are the same but names not so normal compare dataset not work well because it shows differences when the service same (but name not 1:1). In this case i have also in report name and surname so need to count appearance of surname in report 1 and report 2 then if the value is the same skip and count other surname (report have 300-400 records) when in report 1 or report 2 are differences need to show thaht XYZ have 3 values in report 3 and inside report 2 only 1.

Or maybe put data to Chatgpt and it could compare services names some name are
”Service XYZ - consultation” and in second “Service XYZ” etc

What is the error message (if any)?

Please share your workflow

Share the output returned by the last node

Information on your n8n setup

  • n8n version:
  • Database (default: SQLite):
  • n8n EXECUTIONS_PROCESS setting (default: own, main):
  • Running n8n via (Docker, npm, n8n cloud, desktop app):
  • Operating system:
2

  • Remove " - consultation", " - checkup", " - followup"

  • Extract service codes (like “XYZ” from “Service XYZ”)

  • Ignore words in parentheses

  • Standardize capitalization

3

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.