community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

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

How to create a column in an input using another input

I have two sheets sheet1 and sheet2. Sheet1 contains scores for categories while sheet2 has binary data for those categories. e.g.

 

Sheet 1

X  - 20 points

Y-100 points

Z- 300 points

 

Sheet 2 :

X   Y   Z

1    0    1

0    1    0

 

I want to add a new column to sheet2 which canl calculate the scores e.g.

Sheet 2 :

X   Y   Z   Score 

1    0    1  320

0    1    0   100

 

fairly new to Alteryx at this time.

 

Thanks for understanding.

Highlighted
Alteryx
Alteryx

hi @karangupta - see attached workflow. To summarize, we need to transpose Excel2 so that we can assign its corresponding values from Excel1. We perform some calculations then cross-tab it back to the desired format.

This worked. Thank You!

Labels