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

Question

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

FilterRows.csv

Filter Rows1.yxmd

KrishnaChithrathil · Answer

@stevelogue1980

this can be done using 'filter tool'.

Filter Rows1.yxmd

Felipe_Ribeir0 · Answer

Hi @stevelogue1980

It worked?

If yes, please accept it as a solution :)

Thanks!

Felipe_Ribeir0 · Answer

Hi @stevelogue1980

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