Hey everyone,

I’m working on an Alteryx workflow where I need to join two datasets using a common Customer ID field. However, after joining them, the output contains significantly more records than my original dataset.

I’ve checked the data types and confirmed that both fields use the same format, but I’m still getting unexpected results.

Could this be happening because of duplicate keys in one or both datasets? What’s the best way to identify and resolve these duplicates without losing important records?

Any suggestions or approaches would be really helpful. Thanks!