Re-arrange table based on inter table mapping

[PaladinKnight]

I am trying to re-arrange my table and do some inter-table mapping

My input looks like this (I used the binocular function)

Animal	Weight	Diet	Mammal	Color
Tiger	500	meat	Big Bear	White
Polar Bear	1000	fish	Antelope	Brown
Deer	150	grass	Big Cat	Orange

So, my table is disordered 

Is there a mapping I could do (not using fuzzy match) but actual mapping code or something I could write to make it so that I can put some kid of formula like "Tiger" = "Big Cat" and then if a new animal was added, I could just update that code or mapping template. Basically need to make sure the animal column is able to match the corresponding mammal column.

Ideally, I'd want my output to be like this:

Animal	Weight	Diet	Color
Tiger	500	meat	Orange
Polar Bear	1000	fish	White
Deer	150	grass	Brown

[alexnajm]

Sounds like you need to create some sort of mapping file (either in Excel or via a Text Input) so Tiger can be mapped to Big Cat, Polar Bear to Big Bear, etc. Then a Join or a Find Replace can be used once you have that mapping

[caltang]

@PaladinKnight I see you made two posts of the same kind, reference here: https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/How-to-do-intermapping-within-...

My solution shares the same thinking as @alexnajm