Removing data that match another data field set

Questions
1

I’m working with 2 json data sets both containing a similar field ‘SKU’. I want to remove all the entries on the first data set that contains any of the items in the ‘SKU’ field on the second data set.

I’ve been unable to sort this with merge (Keep non-matches). Any advice is appreciated.

Information on your n8n setup

  • **n8n version: 1.47.1
  • **Database (default: SQLite)
  • **n8n EXECUTIONS_PROCESS setting - default
  • **Running n8n via Docker
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

Hi @smartz

You were on the right track I think.
A merge with keep non matches is the way to do this.
There is also a selection for which input to keep on this. You will need to set that to the first input.
Not sure if you have done that already. :slight_smile:

If that doesnt solve it please share a workflow with some sample data so we can have a look. :slight_smile:

4

Hi @BramKn

Thanks for the reply. I think I’ve sorted it. I incorrectly labelled one of the fields so it seems to be working now. Fingers crossed I get no more troubles. :sweat_smile:

5

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