-
1. Re: CSV file headers in alphabetical order?
Matt Coles
Sep 20, 2016 3:12 PM
There's no way VizAlerts can re-order the column headers for you, no...but there might be some trick to getting Tableau Server to sort them in your viz? I'm not sure...
-
2. Re: CSV file headers in alphabetical order?
Well my cheater way of getting them in the order I wanted was to rename them - A.Name; B.EmplId, etc. - but this is a pain and makes the data source messy when needed for another view in the same workbook. Guess I could always structure with different workbooks, but I was trying to have just one trigger spreadsheet to reference. Anyone got any other Tableau-based ideas to try? Is there a reason VizAlerts wanted to alphabetize everything??? Thanks!
-
3. Re: CSV file headers in alphabetical order?
Matt Coles
Sep 20, 2016 3:31 PM
VizAlerts doesn't (or shouldn't be) doing anything different to the CSV Tableau Server gives it. You can see what VizAlerts is getting by simply adding ?:format=csv to the end of the URL for your viz. Whatever you can do to change that output should result in the same thing in the attachment in the alert email you get.
-
4. Re: CSV file headers in alphabetical order?
B.EMPLID C.EMPL_RCD D.BIRTHDATE E.ACTION F.EFFDT G.ACTION_DT H.Hire Dt (Ps Employment) I.JOBCODE J.Jobtitle K.Business Title L.DEPTID M.DeptName N.Supervisor NAME O.Access Coordinator So, Matt, as a test I added the ?:format=csv to the end of my URL and renamed the field in Desktop that was A.Name to just Name...and the above is the result I see in the delivered csv file.
Thoughts?
-
5. Re: CSV file headers in alphabetical order?
Matt Coles
Sep 20, 2016 6:17 PM
I guess I don't really have any thoughts....why exactly is the field order important to you, Lisa?
-
6. Re: CSV file headers in alphabetical order?
I know it seems silly, but this is the order my users want for this particular file. Plus I just want control!
-
7. Re: CSV file headers in alphabetical order?
Jonathan Drummey
Sep 21, 2016 10:06 AM
Re-ordering columns on Tableau's View Data and CSV exports is a big deal to a number of people (it's currently the 4th most popular feature request: https://community.tableau.com/ideas/1123). I'd briefly thought about it as an option for VizAlerts to make it more useful but left it out as it was lower on my priority list.
If you've got any Python skills, we'd be glad for you to contribute! My thought would be to add a content reference option for spelling out the field order like |fieldorder=field1,field2,field3, etc. and then any unlisted fields would be placed at the end.
Jonathan