relabelling columns

[Dan]

Hi,

I'm using the query language and using the aggregation functions along with a pivot which then causes the column names to be labelled with the aggregation function.

Is there a simple way to relabel all the columns to remove the aggregation function from the name? I can see there is a label function for the query but that would require me having a full list of the columns in advance which I wouldn't unless I did two queries.

Is running a initial query to find out the distinct values that will be pivoted into columns or is there a simpler more efficient way to rename the columns. I know that the label name should always be 4 characters so if there is a easy way to rename then I can just do a substring.

Any advice for the best way to achieve this?

Thanks,
Dan

[Dan]

Already fixed using dataTable.setColumnLabel().

Thanks.