community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Upgrade Alteryx Designer in 10 Steps

Debating whether or not to upgrade to the latest version of Alteryx Designer?

LEARN MORE

Trim command on Alteryx + Hadoop

Hello, guys!

 

I'm facing a problem with trim command using "Formula In-DB". When I try to use trim command, I get an error, but when I use ltrim or rtrim everything works fine. So I'm using lrim(rtrim("string")), but this solution is not an elegant one, haha. Do you know some reason why I'm facing this problem with Alteryx + Hadoop? When I use trim command on Hue, everything works fine as well.

 

Best regards

Moderator
Moderator

Hi @jorgemessajunior,

 

Thank you for posting!

 

I have run a quick test myself (below) and could not reproduce the issue. Could you please share your error message?

 

hive_trim_test.png

 

Thanks,

 

Paul Noirel

Sr Customer Support Engineer, Alteryx

Labels