Non exact match (b-a between 0 and 10)

BrianT_FnD

I have two spreadsheets of transactions with no common primary key to join them on. I have transaction date, trans time, amount, location. Everything by trans time matches exactly. Spreadsheet A should be subset of Spreadsheet B. I need to match each transaction in A with a single transaction in B. The trans time in B will be within 10 after the trans time in A. Time and date are ints. So I need to do:

A.date = b.date

a.location = b.location

a.amount = b.amount

b.time - a.time < 10

is this possible? I’m new to alteryx and searching google and here hasn’t yielded any results nor has A LOT of trial and error. Thanks

EDIT: I figured out the non-exact join. I still need to figure out of to make sure A only gets one match in B.

rzdodson

@brian I think I can help you out here, but have two questions for you:

1) When you say "within 10 after", I am assuming it is 10 minutes, correct? Will impact some formula structure for the solution.

2) Also, could you provide a packaged version of your workflow so I can see where you are at?