3 part join with a fuzzy on the date

Hello. I'm brand new to Alteryx, day 3 I think. Wondering if anyone can help me with a little problem

I have a 3 part join on two sets of data. Join is on the account number, a date, and a value.

Works fine, however the matching record might acutally have the date the day before (never after) or 2 days before, or 3, up to 10.

Alas I see the fuzzy match tool but no fuzzy join.

i'm struggling with the best logic to defeat his problem. Has anyone solved such a trick before, and if so how did you do it?

Any help would be much appreciated.

Best regards

Ste

Date Time

Fuzzy Match

Join

Accepted answers

benakesh

Hi @SteAllan ,

Join on account number and value . Add filter to 'j' output from join . In filter check if date difference(DateTimeDiff) is within 10 days . If you need working example share sample data .

All comments

benakesh

Hi @SteAllan ,

Join on account number and value . Add filter to 'j' output from join . In filter check if date difference(DateTimeDiff) is within 10 days . If you need working example share sample data .

SteAllan

Thanks Benakesh - i see what you mean. I get out of the j output multiple results, I just need to work out a filter formula to bring back only the one with the closest date (as there might be two).......

..... but this is a problem I should be able to work out.

Thanks again.

One day i'll have your rank 🙂

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15881

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703