Alteryx Designer Desktop Discussions

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

Removing unwanted rows in data

sriniprad08
11 - Bolide

Hi Team,

 

Hope you are well. I need help. I have a report generated from SAP AFO. I would like to remove the rows marked in yellow.

 

Please find attached the input and output in the excel.

 

Can you please help?

 

Thanks

Sr

 

sriniprad08_0-1651562427185.png

 

3 REPLIES 3
Qiu
21 - Polaris
21 - Polaris

@sriniprad08 
Maybe I have considered it much straightforward, but If a row contains "Result" value, it will be filtered out?

0503-sriniprad08.PNG

sriniprad08
11 - Bolide

Hi @Qiu ,

 

Perfect. Thank you so much. Really appreciate your help.

 

Have a nice day,

 

Thanks,

Sri

Qiu
21 - Polaris
21 - Polaris

@sriniprad08 
Glad to help and you too have a nice day!

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.
Don’t ghost us—pick your favorite now!
Labels