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

Data cleanising problem

himanshu_sharma14
5 - Atom
‎01-03-2024 08:45 PM

I have this uncleaned data where I wanted to count industries where average interest rate is lower than standard interest rate for the industry.

Preview file
18 KB
Labels:
Reply

Accepted SolutionSolved! Go to Solution.

1 REPLY 1
gawa
16 - Nebula
16 - Nebula
‎01-03-2024 09:37 PM

hi @himanshu_sharma14 

Pls refer to the attached WF. Multi-row formula is useful to padding the null rows.

image.png

1225564_gawa.yxzp
Reply
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.
Vote
Hide Results
Don’t ghost us—pick your favorite now!
Labels