Matching date within a date range

Question

Hi,

I am currently performing a reconciliation between 2 sources and have a date that i would like to match with a 4 day tolerance.

I currently have a join tool performing the matching configured to join on specific fields.

I have a attached an example workflow and sample data, it is currently doing exact matching on the date, is it possible to apply an allowance for 4 day tolerance match for the date?

There are currently 2 matches, with the a 4 day tolerance i expect a couple more.

Thanks in advance,

Ash

Tolerance match query.yxmd

LordNeilLord · Accepted Answer

Hey @aka_ash

I would approach this by first joining all of your data together using the primary key (and not the date) the use a datediff calculation to filter anything that is upto 4 days difference....someting like this:

Then you can use a filter to adjust to the tolerance required

grazitti_sapna · Accepted Answer

Hi @aka_ash , Please refer to the screenshot and workflow for your concerns.