Joining two tables : Data Cleaning

[BihaniBhavesh]

Hi All, I'm trying to find a solution to get the below result in Alteryx

Id	Attribute - 1	Attribute - 2
11	ABC	CAT
12	DEF	DOG
13	HIJ

Using the two input tables :

Table-1

Id	Attribute - 2
11	CAT
12	DOG

Table-2

id	Attribute - 1
11	ABC
12	DEF
13	HIJ

[FrederikE]

Hey @BihaniBhavesh,

[Raj]

PFA

[BihaniBhavesh]

Hi , Thanks for the solution, if the order of the id is different i.e. one of them is in ascending and other is jumbled and data set is huge. How can we handle the similar use-case ?

[ahsanaali]

[FrederikE]

Hey @BihaniBhavesh,

Two options for the sorting: Sorting tool like ahsanaali wrote,

or Specific output Order in the union tool.