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