Filter Rows like SQL's Having/Not in condition?

[stevelogue1980]

Hi there!

I have been trying to filter out these 4 rows in Alteryx but could not but hoping someone might be able to help me. 

Attached workflow and csv

[Felipe_Ribeir0]

Hi @stevelogue1980 

You could use the filter tool with the Custom formula !IsNull([Input]) AND !IsNull([parameter]) to filter out these rows. 

 

[Felipe_Ribeir0]

Hi @stevelogue1980 

It worked?

If yes, please accept it as a solution :)

Thanks!

[KrishnaChithrathil]

@stevelogue1980 

this can be done using 'filter tool'.