Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Multiple Match

AnGi
7 - Meteor

HI guys, need your help

I have 2 table, prediction table where users make prediction on a game and on exact final result and another table with the real final results.

I need to assign 3 point to a user if his prediction is correct and another 3 points if also result is correct.

Any idea how to match the 2 tables?

Thanks

 

Prediction table

UserD01 - PredictionD01 - ResultD02 - PredictionD02 - ResultD03 - PredictionD03 - Results….….
Paul12-020-2….….….….
Robertx0-0x1-1….….….….
Andrew11-011-0….….….….
Peter12-121-3….….….….
Angel20-2x2-2….….….….

 

Real Result

GameExact PredictionExact Result
D0112-1
D02x3-3
D0312-0
….….….

 

3 REPLIES 3
atcodedog05
22 - Nova
22 - Nova

Hi @AnGi 

 

Can you provide expected result too.

AnGi
7 - Meteor

Just a new field with final score for each user

 

As i said 3 point for any exact prediction and more 3 point for any exact result

atcodedog05
22 - Nova
22 - Nova

Hi @AnGi 

 

Here is how you can do it.

 

Workflow:

atcodedog05_0-1622820018947.png

 

1. For prediction table keeping user as key convert columns to rows

2. For Game table keeping user as key convert columns to rows

3. Using formula tool creating a matching game name (like D01 - Prediction)

4. Using find & replace to do vlookup on Game & type

5. If the value of prediction table is equal to results table then 3 else 0.

6. Using crosstab to make it a table (this is optional step)

 

Hope this helps 🙂

Labels