topic Re: How to join on matching Provider ID and Expiration Date in Alteryx Designer Desktop Discussions

How to join on matching Provider ID and Expiration Date

snadeau456 — Tue, 02 Apr 2024 21:40:12 GMT

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

Re: How to join on matching Provider ID and Expiration Date

alexnajm — Tue, 02 Apr 2024 21:51:50 GMT

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!

Re: How to join on matching Provider ID and Expiration Date

Raj — Tue, 02 Apr 2024 22:03:52 GMT

@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

Re: How to join on matching Provider ID and Expiration Date

ArmedPenguin — Tue, 02 Apr 2024 22:17:25 GMT

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.

Re: How to join on matching Provider ID and Expiration Date

snadeau456 — Tue, 02 Apr 2024 22:51:39 GMT

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

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

Re: How to join on matching Provider ID and Expiration Date

snadeau456 — Tue, 02 Apr 2024 22:53:21 GMT

Looking for the nonmatches.

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

Re: How to join on matching Provider ID and Expiration Date

ArmedPenguin — Tue, 02 Apr 2024 22:53:27 GMT

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