What are you trying to achieve?
Hi,
I have two data stores. Each one contains a number of records. These records include some information.
Structured data store 1 (orders):
- Address
- Order #
- Tracking # (empty)
And on the other side:
Data Store 2 Structure (Tracking):
- Address
- Tracking #
- Order # (empty).
I need to make a match. Find for Data Store 1 tracking #, which doesn’t have tracking associated with it, bring from Data store 2. I’ll look for it in Data Store 2 and associate it based on the address. I had thought of using Gemini or something similar, as the addresses are similar but not necessarily the same.
Steps taken so far
I had thought about a data store, then an iterator, then a gemini, but my problem is how do I give it access to the Data Store 2 info.
Any ideas or suggestion?
Best regards
