Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Alteryx is here to help you solve your biggest data challenges. Read about the new Virtual Solution Center here.

.csv Output file has extra columns |||||||||

Highlighted
6 - Meteoroid

Hi All, 

 

Please advise why my converted from .xlsx to .csv file contains extra delimiters in the end of the document |||||||  

Number of delimiters related to number of columns. But how can I get rid of it before .csv output is generated 

 

 
 

 

Highlighted
Alteryx Certified Partner

@JuliaSorokina - could you give us more background around your process that generates this CSV file? Are you reading some excel file into Alteryx, and its final output is the CSV you refer to? Going by the image you shared, it looks like your base data set has a null row which is getting output as something with |||||||.

Maybe attempt to remove this null try and try.   

Highlighted
6 - Meteoroid

Thanks @AbhilashR, you are right my intut has row with null values and I missed it. 

Highlighted
Alteryx Certified Partner

Am glad this worked out. Please mark this post as solution accepted if it answered your question, and your issue has now been resolved.

Labels