I have trouble merging some data following this scheme:
Set #1 has some fields: A, B (email), C, D
Set #2 has some fields with one that is common with #1 and can be used as a reconciliation key: B (email), E, F
The expected result is a unique set with all fields: A, B, C, D, E, F where E and F are empty if the email from #1 can’t be found in #2 and where A, C, D are empty if the email from #2 can’t be found in #1
I’ve used the “merge” node but haven’t managed to reach the expected result.
I was wondering whether that could come from the way my flow is built, where I have some input data, use it to extract some more data for some entries, and then try to merge both (because I want to keep the entries .
Any thoughts on how to proceed? That’d help a lot!
Maybe this could work? Using another set node (in lieu of a merge node) and using data coming from the first set node and input data from Gsheet?
Is this data coming from 2 different Google Sheets or is it in the same sheet and layed out like your image? If you can share your workflow we can take a quick look and see what needs to be changed.
That looks like a link to a cloud environment, We don’t have direct access to those instances. You can export the workflow and upload it here that should let us see it.