Alteryx Designer Desktop Discussions

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

Removing rows that contain Zeroes

Khristian_Evans
6 - Meteoroid

Hi, I have a set of data and some rows the Amount column populates with zero, how would I go about removing the rows with zero entirely from the output?

2 REPLIES 2
alexnajm
16 - Nebula
16 - Nebula

Filter tool to where [Amount]!=0 (amount is not equal to zero) and using the T (or True) anchor

Raj
14 - Magnetar

@Khristian_Evans 
Filter tool will be best tool to tackle such situation.
where condition will be.
[Amount]!= 0

workflow for reference is added.

hope this helps.
.

Labels