Alteryx Designer Desktop Discussions

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

Not blank on multiple columns

wonka1234
10 - Fireball

Hi,

 

How do I remove blanks for certain columns in my workflow?

 

GEtting an error:

 

wonka1234_0-1647963122822.png

 

 

 

Thanks.

5 REPLIES 5
Kenda
16 - Nebula
16 - Nebula

What is the error that you're getting @wonka1234 ?

binuacs
20 - Arcturus

@wonka1234 try the formula !IsEmpty(Trim([Field]))

wonka1234
10 - Fireball

@Kenda  getting error: Parse Error at Char (364) : Malformed function call.

 

Looks like the error is occuring at the end of my filter.

Kenda
16 - Nebula
16 - Nebula

@wonka1234 

 

It is difficult to help without being able to actually see your full expression, but my recommendation would be to double check all of your parenthesis. 

 

If that doesn't help, could you possibly share your full expression? 

wonka1234
10 - Fireball

I was missing a bracket, sorry.

Labels