How to join on matching Provider ID and Expiration Date

[snadeau456]

The provider IDs and Dates are in the same formats; why won't they join?

[alexnajm]

We won't be able to tell what the issue is unless we see the data you are trying to join. Ideally we'd also like to see your workflow itself too!

[Raj]

@snadeau456 
there could be several reasons why they're not joining properly:
Data Type Mismatch
Formatting Differences
Null Values

it will be better if you can give more clarity on this
will be happy to help

[ArmedPenguin]

Can you post a sample work flow?

What exactly are you trying to do? Provider ID and Date, while maybe the same format, seem fundamentally different from each other. A join is looking to match exact values. I don't see where that would happen between a date and ID. But again, without further information to go on, can't be sure.

[snadeau456]

The Provider ID between the two fields are in the format.

The dates between the two fields are in the same format.

[snadeau456]

Looking for the nonmatches.

The PIN and the date must be a no match but they are actually a match.

[ArmedPenguin]

Gotcha. Do you have an example workflow or example data?