Basic table tool formatting

Question

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?

grazitti_sapna · Answer

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.

Qiu · Answer

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.

Basic table tool formatting.yxmd

AnandKumar1 · Answer

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:

IDNameAgeRegion1Abc22APACIDNameAgeRegion2Der28APACIDNameAgeRegion3Fe21EMEAIDNameAgeRegion4WE25APAC

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?