I’m working, on what I thought would be a very simple workflow, but have been lost for hours trying to remove duplicates when comparing a RSS Feed and items in NocoDB.
Describe the problem/error/question
Why can’t I compare the title from the RSS Feed and NocoDB?
What is the error message (if any)?
I can’t seem to connect the 2 original data sources together to check duplicates.
Please share your workflow
Share the output returned by the last node
No path back to referenced node [item 0]
There is no connection back to the node ‘NocoDB - GET - Articles’, but it’s used in an expression here.
Please wire up the node (there can be other nodes in between).
Went with the Code node and used the following to dedupe:
// Get the existing articles from the previous node
const existingArticles = $items(“NocoDB - GET - Articles”).map(item => item.json);
const newArticles = $items(“Filter”).map(item => item.json);
// Create a Set of existing article titles for quick lookup
const existingTitles = new Set(existingArticles.map(article => article.title));
// Filter out new articles that already exist
const filteredNewArticles = newArticles.filter(article => !existingTitles.has(article.title));
// Return the filtered new articles
return filteredNewArticles.map(article => ({ json: article }));