Filter data by another input

There are two inputs, hoping to filter out some records in another input with a certain field in one input. I have tried Merge and Compare Datasets, but they don’t seem to work.


## Information on your n8n setup
- **n8n version:1.16**
- **Database (default: SQLite):**
- **n8n EXECUTIONS_PROCESS setting (default: own, main):**
- **Running n8n via (Docker, npm, n8n cloud, desktop app):Docker**
- **Operating system:Windows 10**

@shangzhw , could you be more specific what you are trying to achieve, and what is actual outcome of your setup?

The screenshot you provided is for the scenario where you want to find records in both datasets (Airtable and Node) with the same ID but output only the data from Notion when the match found. If that is what you need then it should work like that.

I’m sorry, the previous description was not complete. Your understanding is very accurate, this is what I want to achieve, but when I confirm that the two have data that can match, the output is still empty. I want to know if there is something wrong with the settings.

@shangzhw , I believe your problem is because of IF node. It shouldn’t be there. Remove it from the equation and have Airtable connected in Input1 and Notion trigger to Input2 via Set node instead if IF. Let Set node add the ID composed of the two properties if the incoming data. Here’s an improvised example.

Removed the IF, deleted the remaining records in airtable, but the output is still empty.
image

Thank you, it worked! However, it was achieved by generating a new field in advance with the matching content, and using field names instead of expressions in the Merge. Can’t expressions be used in Merge? Or is this a BUG?

image

The answer is right below the inputboxes. The name of the column is needed here for the merge to do its thing.
So when using an expression you normally get a value of that field which is not helpful.

Of course if you have the name of the field to be merged in your input data you could use the expression, but that isn’t what you are doing here.

I expect that it would be beneficial to you to go through the 2 course n8n provides. :slight_smile:

1 Like

Thank you very much