Creating link between two datasets

Question

Hi everyone,

I want to design a database. I have two tables:source1 and source2.

I want to have access to search an IP and find the related records in both tables (like in the image.png file)

How can I create a table to link these two tables? How can create a key for each of the tables?

source1.xlsx

source2.xlsx

image.png

FinnCharlton · Answer

@Saraabdi955, what do you mean by "not unique"?

Do you mean there is a "Source IP" and "Destination IP" field?

-To deal with this I transposed the data - turning Source IP and Destination IP into one column. Another column ("IP Type") was created telling us if an IP is "Source" or "Destination".

Saraabdi955 · Answer

@FinnCharlton

Sounds great.

Here IP is not unique, right?

If you want to make this column unique, what would you do?

FinnCharlton · Answer

@Saraabdi955 , here is what it seems you're looking for:

It's an app that allows you to search both tables and returns matching IP addresses, along with their ports:

Hope this helps, let me know if you're looking for something different

IP Searcher Packaged.yxzp