Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.
Free Trial

Alteryx Designer Desktop Discussions

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

How to create a column in an input using another input

karangupta
6 - Meteoroid

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.

2 REPLIES 2
CarlDi
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.

karangupta
6 - Meteoroid

This worked. Thank You!

Labels
Top Solution Authors