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
Solved! Go to Solution.
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
Thanks @LordNeilLord and @grazitti_sapna ,
I believe I can utilise this method to get the desired result.
Thanks Again,
Ash
Great answers thanks @LordNeilLord and @grazitti_sapna I've been struggling with the same issue as @aka_ash and just found this post.