Let’s talk Alteryx Copilot. Join the live AMA event to connect with the Alteryx team, ask questions, and hear how others are exploring what Copilot can do. Have Copilot questions? Ask here!
Start Free Trial

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