Help with connecting 2 tables - extract data for multiple dates for a unique ID

[MROGK]

Hi,

Can someone help me extract the potential $ value for the same ID on 2 different dates? I have 2 input tables. I showed the output I'm interested in the attached excel. Thanks.

[jbichachi003]

Hi @MROGK,

Alteryx solution attached with what I believe you were trying to achieve.

Note, I didn't have to convert any of the dates to a proper date type format (I left them as strings), but you can't have two columns with the same name, so I renamed the Potential $ fields.