Duplicate grouping field specified on the Left side

Question

Hello, i'm having an issue with this error on my Join stage and need urgent help. See snippet.

My left input is an xlsx file with the following records without duplications:

However, i keep getting the same error. Please advise.

Note: I applied the same logic in another workflow without any error.

apathetichell · Answer

My hypothesis. Switch to another field. switch back.

Georgia_H · Answer

@atcodedog05 @apathetichell

I don't think joining same key multiple times are not allowed. Joining same key multiple times worked for all my other Workflows. They have been running for years now. See snippets.

My objective is to match QID = PATCH_QID and QID_VULN_QID and when there are matches, then rate the severity as S2. Therefore, I need 2 keys for the join at the same time.

This is my new Workflow and I'm applying the same concept but it gives me the error.

My Alteryx version is 2021.1

atcodedog05 · Answer

Hi @apathetichell

You are right i check on the same it seems to work even if key is specified mutiple times.

Could this be something fixed in newer version 🤔

My Alteryx version is 2021.1 @Georgia_H what is your Alteryx version?