This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I have got the CSV output from Alteryx. but datas coming without proper format. certain columns coming in left aligned manner and certain coming in Right aligned.. certain column has both text and numbers.. so it has left aligned(for numbers) and right aligned(for text)..
a CSV output contains no formatting instructions. If you read a csv into another application (e.g. Excel), that application may apply formatting. If it thinks that a column is text, it will be left aligned. If it thinks that it is a number, it will be right aligned.
I'll forward this post to @SeanAdams for his feedback too.
Alteryx ACE & Top Community Contributor
Chaos reigns within. Repent, reflect and reboot. Order shall return. Please Subscribe to my youTube channel.
Why do you see alignment when you open this up in Excel? Well - Excel looks at this data, and makes some assumptions about the types - and left aligns things that it guesses are dates or text, and right aligns numbers. If you want to see what's ACTUALLY in the CSV file - open it up in Notepad instead.
If you want more detailed formatting - there are 3 options:
b) you can output to Excel using a hidden sheet - and then use formulae to do a much more professional looking output - @MarqueeCrew has done a lot of this and there may be a post that he can refer you to
c) you could use a Python library. I've not done this myself, but people in my team have - so this would be a google.com research project to get this up and running (the benefit being that if you get this running, that may be your first blog post on the community with a simple how-to guide).