Alteryx Designer Desktop Discussions

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

Replicating Comparison Operator used in the JOIN conditions of a SQL statement

Milliman
5 - Atom

Hello,

 

I'm wondering how I could replicate the comparison operator used to filter dates in the JOIN ON statement below:

 

SELECT Key, Date FROM A

LEFT JOIN B

ON (A.Key = B.Key)

AND (A.Date > B. Date)

 

Thank you!

2 REPLIES 2
afv2688
16 - Nebula
16 - Nebula

Hello @Milliman ,

 

You can replicate it by using a join, union and filter tool.

 

Untitled.png

 

If you need anything else let me know 🙂

 

Regards

R726319
5 - Atom

This approach works for a SQL Where clause and not as a left join.

Labels