ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests Early 2026. Make sure to check your account preferences in my.alteryx.com to make sure you have filled out your security questions. Learn more here
Start Free Trial

Alteryx Designer Desktop Discussions

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

2 Red Dots trailing a String?

JordyMicheal
11 - Bolide

Has anyone ever seen this before?

I couldn't get it to filter out so I copied and pasted the values from the table and it has 2 red dots at the end....

 

A bunch of the cells I have seem to have this around a certain grouping.

Can anyone tell me what it is?

 

Thanks

 

 

2 REPLIES 2
ShankerV
17 - Castor

Hi @JordyMicheal 

 

Those 2 red dots are special characters

It is created when you press ALT + 7 in Excel

 

So I believe you are inputting the data's from Excel 

 

Use the Data Cleansing tool to remove the special characters and proceed upon

 

Hope this resolves your issue.

grazitti_sapna
17 - Castor

@JordyMicheal , This might be some special character coming up in your data which is visible as red dots. You can try opening the file in notepad++ and check the format. If possible can you please share the file in which this data is coming may be I can do the analysis from my end.

Sapna Gupta
Labels
Top Solution Authors