I want to achieve what should be simple but my tired brain is struggling.
I have 2 data sources (A and B) each containing a list of records. I want to check if a record is present from data source A is present in data source B? If it is not present then create it in data source B.
I am struggling because the IF node looks to compare 2 values. In this case I am looking for the absence of all values for a record and wanting to trigger an action based on that absence.
How?
I have tried with the merge node, where I think the solution lies, with no joy.
The records contain name email and a unique registration number. I don’t think the values are relevant here as its the absence of the record entirely that I am looking to use as trigger or condition. The values will ultimately be used to create the record in datasource B.