Join the Inspire AMA with Joshua Burkhow, March 31-April 4. Ask, share, and connect with the Alteryx community!

Alteryx Designer Desktop Discussions

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

Reference fields with square brackets

PhilipMannering
16 - Nebula
16 - Nebula

I have a field called "Field[1]" and the square brackets in the name interferes with the square brackets denoting a field. Looks like you can add a second closing square bracket, but I wondered why that was the case? Anybody got an explanation? Is this documented?

Screenshot 2023-06-26 124844.png

2 REPLIES 2
Qiu
21 - Polaris
21 - Polaris

@PhilipMannering 
I searched the Help doc and get no luck, I guess it is not documented yet?

2 square bracket mean anything in your programing world? 😁

But I did find one in the community related.

https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Parse-Error-at-char-1-Unknown-...

 

PS: New profle pic still not matches the person I see at the Inspire.🤣

flying008
15 - Aurora

Hi, @PhilipMannering 

 

If your field name contains  a right square bracket ']', then it will be eat by formula before parse(because it always matched 1st '['), to avoid the case, you need manual added a ']' to padding it each position.

Labels
Top Solution Authors