Happy 8th birthday to the Maveryx Community! Take a walk down memory lane in our birthday blog, and don't miss out on the awesome birthday present that all Maveryx Community members get to take advantage of!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

merging tables - different data types

7 - Meteor

Hi all, 


I'm looking to combine these two tables but having trouble - i was thinking to make a helper column based on CustomerID and purchase date but am having trouble because they are different data types. I can't do it based on purchase time alone because some have the same time. How do I do this? Thanks!!


Table 1

CustomerIDPurchase numberPurchase time
1120/07/2021 10:30
1225/07/2021 17:00
3121/07/2021 13:00
4123/07/2021 15:51
4226/07/2021 07:00


Table 2

CustomerIDPurchase numberPurchase timeItem numberStore number
1 20/07/2021 10:30305
1 25/07/2021 17:00406
3 20/07/2021 10:30507
4 23/07/2021 15:51207
4 26/07/2021 07:00305
17 - Castor
17 - Castor

Hi @vivian123 ,


If CustomerID and Customer Date together is enough for you to combine both tables, you can use a join tool and select both columns as key fields.


You don't need to combine both columns into one as you would do in excel to use the vlookup function.





Fernando Vizcaino


Alteryx Alumni (Retired)

hi @vivian123, if you need further details on how to join different data sources on Alteryx, or similar functionality as vlookup on Alteryx refer to this interactive lesson https://community.alteryx.com/t5/Interactive-Lessons/VLookUps-with-Designer/ta-p/80201#done