Question

Specifing order of the column in pivot table?


Badge

Hi,

I using FME to generete a Pivot table using a template (existing Excel table) which is working just fine. The only problem is that I can´t seem to control where the column (with the explaining text) is located. In the original excel-table it´s located in the beginning (column A) but in the FME generated excel-file it´s located in the last column of the sheet. Is it possible to change that?

Christian

 


2 replies

Badge +1

That's interesting. Are you appending type_name and status_name to source data.

Just a question. what will happen if you rearrange order of user attributes in writer and put type_name and status_name on first position?

Badge

Hi,

type_name and status_name are coming from the original file. To answer your question, the only columns that are exposed from the user attributes are status_name and type_name and it doesent seem to do anything rearranging the two attributes.

Christian

Reply