I just upgraded to Alteryx Designer 10.6. I am trying to use the "TrimLeft" function, and I am getting an error that does not make sense:
Can anyone provide me with some direction as to why this might be happening?
Thank you
Solved! Go to Solution.
TrimLeft([Grouping],"10")
The trimmed text was a number.....
Cheers,
Mark
The TrimLeft() function requires two strings as parameters. In your example, you have the value "10" without quotes, so I am thinking that is where the mismatch is.
Are you really just wanting the left 10 characters? Then just using Left() would work there.
Thank you. It looks like "Left" is the function I need, not "Trim Left". I appreciate your help!
That's funny. I took you literally thinking that numbers like 101234567890 needed to become 1234567890. It didn't occur to me that left(field,10) or 1012345678 is what you wanted.
Cheers,
Mark