Creating link between two datasets

[Saraabdi955]

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?

[FinnCharlton]

Hi @Saraabdi955 ,

You can relate tables in Alteryx using the Join tool, like this:

To help any further it would be great if you could provide some more information:

-How are the two tables "related"?

-What do you mean by "creating a key" for the tables?

-When you search for an IP, what do you want to be returned? The matching IP addresses in either table? Matching IPs that appear in both tables only?

[Saraabdi955]

Thanks, @FinnCharlton 

- How are the two tables "related"?

ans: there are some mutual IPs in two tables. I want to find the relationship between IPs.

-What do you mean by "creating a key" for the tables?

ans: I need to define the primary key for tables: source1, source2, and link. But IP is not a unique column!

-When you search for an IP, what do you want to be returned? The matching IP addresses in either table? Matching IPs that appear in both tables only?

ans: matching IPs and related columns to each of them. for example: ports

[FinnCharlton]

@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

[Saraabdi955]

@FinnCharlton 

Sounds great.

Here IP is not unique, right?

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

[FinnCharlton]

@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".