community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

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

Formating in Alteryx

Highlighted
Meteor

Hi Alteryx Team

 

How do you format the output(excel) in alteryx in such a way that -

This output -

Age IndianAmtType
1Yes-28000000Match
10No36000000Match

Changes to this - (center and color of first row to red)

Age  Indian    Amt Type
1Yes-28000000Match
10No36000000Match

 

Is this possible in Alteryx or will I always get a raw data?

 

Quasar

You can format the table headers using the reporting tools

Alteryx
Alteryx

As above, you'd want to dive into the reporting tools.

 

Specifically the table tool and then render.

 

In the table tool you'll need to use the default settings to adjust your header text and background colour:

Style.png

 

And then column rules to justify the header to the center:

Rule1.png

 

Example attached below too...

Alteryx
Alteryx

@stevegeorge In order to keep the formatting that you would like in excel, I would recommend formatting the excel file that way, and writing out to a named range in that file. This will keep the formatting and update the values. To write out to a named range, write the name of the range where the sheet name is usually written (after the |||). Be sure to select "Overwrite Sheet" as well.

 

Output Tool.PNG

 

If this does not give you your desired result, try downloading the Legacy Excel Driver and write to the same output file and range.

 

Let me know if this is what you're looking for.

 

Luke

Labels