Alteryx Designer Desktop Discussions

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

Select Records Tool- Parse Error

trvu8447
6 - Meteoroid

Hello! I was going through my dataset and was selecting individual records and ranges of records within the Select Records tool, and it kept popping up with this error message:  "Select Records (10) Tool #10: Parse Error at char(1208): An expression cannot end with an operator". I am not sure what's going on; all of my selections have followed the correct formats. I have attached an image of my configuration window for this tool and a picture of the error on the tool. Thank you so much in advance! 

3451834E-B0DA-4E67-9164-24B878D72031.jpegCD20899D-8326-4043-B5F8-ADCF9A499144_4_5005_c.jpeg

5 REPLIES 5
Emil_Kos
17 - Castor
17 - Castor

Hi @trvu8447,

 

I don't have a clue as well but maybe you can try removing some of the data to check in which area there is an error. 

 

Or maybe create a new tool and paste everything there. 

 

Apologies but it look correctly so I would limit the amount of the conditions to check in which part there is a mistake. 

 

Good luck 🙂

AngelosPachis
16 - Nebula

Hi @trvu8447 ,

 

Agree with @Emil_Kos , I can't see anything wrong to the range you are displaying in your screenshot as well. But note that there is a scroll bar appearing on the right, which might mean that what's causing the error might (should) be further up or down

 

AngelosPachis_0-1638050726029.png

 

trvu8447
6 - Meteoroid

I cut down on the number of conditions, and it's still presenting me with this error. 034F5154-E49D-4742-A929-293BD7CCE981_4_5005_c.jpeg

danilang
19 - Altair
19 - Altair

HI @trvu8447 

 

I was able to reproduce your error by including a blank line in the range list, like this

danilang_2-1638101138328.png

The error also occurs if the blank line is at the end of the list.  

danilang_3-1638101239123.png

 

Check your list of ranges for blanks lines.

 

If there aren't any, can you post a minimal sample of your data and workflow? 

 

Dan

 

 

 

trvu8447
6 - Meteoroid

I checked for blanks and that made it work perfectly! Thank you so much again for your help 🙂 

Labels