Basic table tool formatting

[AnandKumar1]

Hi,

I'm using Basic table tool to create a report of my extract table which has almost 200 columns.

I'm using basic table because i wanted to do some changes in font,color and background. 

But i'm getting repeated column headers for all my record. How to remove this and keep one single column header?

Second, is it possible to extract the same formatted output with color,background and fonts. And use it in excel format and then mail to someone?

[Emil_Kos]

Hi @AnandKumar1,

What do you have on mind saying repeated column headers. Can you share an example?  

Regarding the second question you need to use render tool:

https://help.alteryx.com/current/designer/render-tool

You can check the examples in Alteryx to learn more about it:

[AnandKumar1]

I mean i'm getting many headers in browse tool. For each row there is a header. I want only one column header like we have in excel files.

My output looks like:

ID	Name	Age	Region
1	Abc	22	APAC
ID	Name	Age	Region
2	Der	28	APAC
ID	Name	Age	Region
3	Fe	21	EMEA
ID	Name	Age	Region
4	WE	25	APAC

But i want only columns header fro all my records.

When i unchecked the group by option, i did not get any output at all.

Second problem is that, i wanted to change the  font, color and background of my output and use it as excel file and then mail to someone. Is it possbile?

[Qiu]

Just to add to others reply.

1. For the repeated header, kindly check you have group anything when using the Table Tool.

2. You can customize the Table Style for the whole table or by Row Rules

3. You can output an Excel file with Render Tool.

If this meets your desire, kindly mark it as accepted. Thanks.

[grazitti_sapna]

Hi @AnandKumar1 , can you share the configuration of your basic table tool?

I think you are grouping the records on the basis of RecordID maybe that is the reason why the column headers are being repeated.

And, yes you can extract this file using render tool and create a new workflow using email tool where you can use this file as an attachment and send it to the other person.

Thanks.