Alteryx Designer Desktop Discussions

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

Split data help

Joggy1122
5 - Atom

Hello,

 

I'm trying to create a auto calculation for the return/loss of each person, but I tried so many times, still cannot make it. 😭😵

 

The example is the excel

 

I want to have the result like 

         Poker  Dice  Roulette  Craps

Tom   -150     90   80           -80

Jane  -250     440   150         -450      

Ben    900    -430   -20         20  

Anna  -100     380     -10      0

 

 

Thanks and much appreciated for your assist. 

1 REPLY 1
Felipe_Ribeir0
16 - Nebula

Hi @Joggy1122 

 

Take a look at the attached workflow.

profit.png

Polls
We’re dying to get your help in determining what the new profile picture frame should be this Halloween. Cast your vote and help us haunt the Community with the best spooky character.
Don’t ghost us—pick your favorite now!
Labels