Joining two columns

[asaditm]

Hello. I have two separate datasets, and both have 'Age' columns. I want to have a single column of age where both the columns are merged via a range or some other mechanism. How can I do that?

Thank you.

[DanHare · Accepted solution]

Hello !

Alteryx doesn't allow a range based Join, so there a couple of ways of achieving this ;

• Use custom buckets in the Tile tool, or 
• A Text Input tool with your age buckets that you Append to your dataset then filter out the rows that match

Hope this helps.

[asaditm]

Thank you Dan.

[DanHare]

Welcome to the Community !