I need to send fields from one table to another (in another base)… I want to add ONLY those that donlt exist yet, i.e avoid duplicates.
I need to do this automatically as a required step in a MAKE workflow.
This is what I’ve been trying (and am stuck)
Data flows from Table A to Table B.
For TableB, I create a view with only the records that haven’t gone through this process, so I do not repeat the search over teh full table everytime
On this view, I run a SEARCH RECORDS module in MAKE. The output is a series of bundles.
I need to extrat only the one fied of interest from all output bundles and put them in an array.
So then I can iterate over this array with another SEARCH RECORDS to check one by one if they exist or not in destination table… then I add a record with all resulting entries which do not already exist.
This seems way too convoluted, but I’m struggling to figure out a more direct way to do it…
Surely there is a better way. I mean, it’s fairly simple: “from within MAKE, copy form one table to another only non-existing values”. Just can’t see it!
Alternatively, I could just copy the whole thing without checking and then delete duplicates (via AT extension?)…but then I’d need to trigger this from within MAKE and not sure I could do that.
Guidance is appreciated.