CSV output - Header format change
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi,
I have created one Workflow and I used output as csv format. when i open the file, I am getting proper output. But I need to make the header unique like Bold , background colour, center aligned something like that..
Is there any way we can get the output like that from Alteryx itself
Solved! Go to Solution.
- Labels:
- Developer
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hello @Karthick461 :
Yes, this is possible using the Reporting Tools. A Table Tool allows you to format the records in the desired way. The table can then be written to Excel using a Render Tool.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
So I have to use Table , then Render tool and Output tool(csv) to get my answer?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Correct, the Output Data tool does not write files with formatting. To do so, you will need to use the Reporting Tools. I've attached a sample workflow demonstrating how to do this. However, I'd like to clarify that CSV files do not store formatting. If you want to save the data with formatting it must be saved as an Excel (.xlsx) file.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I am getting g below Error while opening your sample file . I am using 2021.1 version.. not able to use 2021.3 because of some issue in saving in gallery. Do you have this file in 2021.1 version
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @Karthick461, the following article explains how this can be done. I've attached the modified workflow for you here.