Need to match values for a range

Hello everyone,

I am currently working on matching two Alteryx sheets and need assistance with implementing a variance requirement. The sheets contain data such as EmployeeID, ClockINDate, ClockOutDate, TimeType, and TimeEntered. I would like to use the combination of EmployeeID, ClockINDate, ClockOutDate, and TimeType as the key for matching. However, I also need to consider a variance of +/- 0.5 units when comparing the TimeEntered field.

I initially tried using a join tool, but encountered issues such as getting a cartesian join if TimeEntered is not included as a key, or the join not happening at all if TimeEntered is used as a key. To address this, I would appreciate any guidance on how to handle the variance requirement effectively.

Thank you in advance for your assistance and support!

Common Use Cases

Best Practices

Transformation

Accepted answers

CoG

Here is a sample workflow that should do most of what you need, if you need to identify missing records, you can join back to original data on RecordID to identify unmatched records:

Happy Solving!

Sample Workflow.yxmd

All comments

binu_acs

@VinayDama Are you comparing row against row of the two input files? I mean the first row from the yellow highlighted file against the first row from the green file?

VinayDama

Thats right. I need to compare rows from yellow file to green file. This would mean first row from yellow sheet will be matched to first row from green sheet because they seem to be closest

binu_acs

@VinayDama in that case add Record ID tool after each input files then join using the key "RecordID".

VinayDama

There are chances where some records in either of the files which may go missing due to the product reasons. If we have some missing records, I cannot use recordID.

CoG

Here is a sample workflow that should do most of what you need, if you need to identify missing records, you can join back to original data on RecordID to identify unmatched records:

Happy Solving!

Sample Workflow.yxmd

VinayDama

Andrew - This works! I can't thank you enough.

I will build my workflow based on this.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703