We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun 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