merging tables - different data types

[vivian123]

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

CustomerID	Purchase number	Purchase time
1	1	20/07/2021 10:30
1	2	25/07/2021 17:00
3	1	21/07/2021 13:00
4	1	23/07/2021 15:51
4	2	26/07/2021 07:00

Table 2

CustomerID	Purchase number	Purchase time	Item number	Store number
1		20/07/2021 10:30	30	5
1		25/07/2021 17:00	40	6
3		20/07/2021 10:30	50	7
4		23/07/2021 15:51	20	7
4		26/07/2021 07:00	30	5

[fmvizcaino]

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.

Best,

Fernando Vizcaino

[mtouiti]

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