Joining two data set

[BihaniBhavesh]

Hello, I'm looking for solutions where joining two table data based on id would provide output next to each other .. displayed in the below fashion:

Note : I've tried joining based on the record position, unfortunately results are not similar. And cartesian rows are returned while we perform multi-join by specific field.

Output table :

id	Attribute-1	Attribute-2	Attribute-3
11	Cat	pale yellow	UK
11	dog	brown	India
12	Rat	black
14	horse	white	USA
14	cow	brown	India
14	cat

Using the information from three table :

Table-1

id	Attribute-1
11	Cat
11	dog
12	Rat
14	horse
14	cow
14	cat

Table-2 :

id	Attribute-2
11	pale yellow
11	brown
12	black
14	white
14	brown

table-3 :

id	Attribute-3
11	UK
11	India
14	USA
14	India

[Christina_H]

Use tile tools to label the rows for each ID, giving you something to join on.

[SeanAdams]

Hey @BihaniBhavesh - given that they all share the same key - I'd use the Multi-join - that way you can do this all in one too.

[wwatson]

@BihaniBhavesh Your IDs are not unique in the attribute tables so are many to many rather than one to one. However as @SeanAdams says a mutli-join tool would be the way to join these tables.