Start Free Trial

Alteryx Designer Desktop Discussions

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

Reading CSV format

SH_94
11 - Bolide

Dear Community,

 

I would like to ask how can we read the csv format for the file below. I currently using macro to read all the file.

SH_94_0-1645426767675.png

 

Appreciate if you could show me how to read the csv file format below by sharing the workflow on how u fix this.

 

Thank you.

 

3 REPLIES 3
binu_acs
21 - Polaris

@SH_94 your .csv file has some problem, in order to review the data please use the below settings and verify the data 

 

binuacs_0-1645429083015.png

 

SH_94
11 - Bolide

Hi @binu_acs ,

 

However, this csv i generated from system. So i also wondering on how to fix the issue for long time.

 

 

May i know how to change the format into readable format without the " ".

 

Could you share with me the workflow ?

 

Thank you.

binu_acs
21 - Polaris

@SH_94 you can try something like below 

binuacs_0-1645438195881.png

 

Labels
Top Solution Authors