Skip to main content
Question

Specifing order of the column in pivot table?


Forum|alt.badge.img

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

zzupljanin
Contributor
Forum|alt.badge.img+4
  • Contributor
  • March 29, 2017

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?


Forum|alt.badge.img
  • Author
  • March 30, 2017

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


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings