ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests Early 2026. Make sure to check your account preferences in my.alteryx.com to make sure you have filled out your security questions. Learn more here
Start Free Trial

Alteryx Designer Desktop Discussions

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

Not blank on multiple columns

wonka1234
Boule de feu

Hi,

 

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

 

GEtting an error:

 

wonka1234_0-1647963122822.png

 

 

 

Thanks.

5 RÉPONSES 5
Kenda
16 - Nebula
16 - Nebula

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

binu_acs
Polaris

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

wonka1234
Boule de feu

@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
Boule de feu

I was missing a bracket, sorry.

Étiquettes
Auteurs des meilleures solutions