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