Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Append IF [B_Date] Between DateTimeDiff([A_Date],-11,'month') and [A_Date]?

Matthew
11 - Bolide

i've built a workflow where i need to join two tables, but the join is unusual.

 

table A has a list of dates, and i need to join table B onto it anywhere the date on table B is somewhere within the past 11 months of the date on each row of table A

 

i solved it by using the Append tool, and then following it with a filter tool to remove rows where the B_Date falls outside of the range i'm looking for

 

after i finish the append, i can then summarise the data the way i need it

 

i can get away with this because my tables are fairly small.. but it's still waaay bigger than it should be.. the append tool warns you if you go over 16 rows.. i'm appending 623,000 rows onto 200 rows... (meaning i wind up with 124,000,000 rows).. that's a manageable number.. But what if i needed to append 623,000 rows onto 44 million rows?

This solution works this time, but there has to be a more computationally efficient way to do this... right?

 

NothingButThyme_0-1637708198462.png

 

 

10 REPLIES 10
Qiu
20 - Arcturus
20 - Arcturus

@Matthew  @JarekSkudrzyk 
Glad to help and thank you so much for the kind words.

Labels