Get all the data that has the same information and merge it then count

Questions
1

Hey there! I’m here again haha.

I’m having a hard time thinking on how can I merge field that has same content and then count it after.

For instance, I have a field Country, Domain, Result - if they have the same content I want the output to be:

Country: (content)
Domain: (content)
Result: (content)
Count: (how many of these are the same)

Here is my current workflow:

Thanks! Hope you all are having a good day!

2

It looks like your topic is missing some important information. Could you provide the following if applicable.

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

up for this, im stuck

4

up for this, still trying to figure this out

5

I think you need to approach this in a different way.

first you want an If or Filter Node that checks the prerequisites.

Then you need to group by one of the fields.
You can check the forum for “Group by” examples or search for javascript examples. (I don’t have an example at hand)

1 Like
6

i did use a switch, thank u

7

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