Any ideas on how to approach this task?

[ipoblete]

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

Screenshots: scenario setup, module configuration, errors

[ipoblete]

Hi @Qais
thank you for your guidance. You gave me a good idea of how I could approach it. I made I think an improvement that I’ll share in case anyone is helpful. I put the tracks together and added them in a text…with that I give gemini all the options and tell it to look for the one that matches or is the closest match.

Thank you very much,