Let’s talk Alteryx Copilot. Join the live AMA event to connect with the Alteryx team, ask questions, and hear how others are exploring what Copilot can do. Have Copilot questions? Ask here!

Alteryx Designer Desktop Discussions

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

IF Statement with data from one column populating another.

Adam_B
8 - Asteroid

Hello,

 

I have a data set with a column named "How Many SBRs were done for Q1?" I need to populate the result of that column (can be 1-9) into a new column called Q1 with the respective number from the other column. 

 

Attached is dummy data.  

 

I believe it will be multiple IF statements for the range that I need, but I am not sure. 

2 REPLIES 2
binuacs
21 - Polaris

@Adam_B Not sure I understand your requirement. Is that something you are looking for?

 

binuacs_0-1681755831428.png

 

Adam_B
8 - Asteroid

@binuacs Thank you!

Labels
Top Solution Authors