Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.
community Alteryx IO Mission Control
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
Free Trial

Alteryx Designer Desktop Discussions

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

Multi-row Formula not working

Link86
8 - Asteroid
‎06-22-2022 10:25 AM

Hello, I have the below workflow with the formula if [Topic 1] = [Row-1:Topic 1] then [Row-1:Topic 1] else [Topic 1] endif. However, as you can see in the image, it is not copying down. Is someone able to help me out with this and tell me what I am doing wrong?

 

Chris86_0-1655918478954.png

 

Dogs-cats-pigs-chickens.yxzp
Labels:
Reply

Accepted SolutionSolved! Go to Solution.

3 REPLIES 3
IraWatt
17 - Castor
17 - Castor
‎06-22-2022 10:35 AM

Hey @Link86,

Why were you grouping on line number? Is this the output you were looking for?

IraWatt_0-1655919280332.png

IF isempty([Topic 1]) THEN [Row-1:Topic 1] ELSE [Topic 1] ENDIF

 

workflow.yxzp
Reply
Link86
8 - Asteroid
‎06-22-2022 10:43 AM

This is exactly what I was looking for. Thank you

Reply
IraWatt
17 - Castor
17 - Castor
‎06-22-2022 11:36 AM

No worries @Link86 ! 😄

Reply
connect with mentors
designer new user guide
Labels
Top Solution Authors
View All