Skip to main content
Question

Dynamic writer: Excel column reordering to alphabetical

  • January 16, 2026
  • 2 replies
  • 56 views

caromc
Contributor
Forum|alt.badge.img+2

I have written a workbench were user can upload a excel spreadsheet and the workbench will convert the coordinates in the spreadsheet to a variety of different coordinate systems.
The last step is a dynamic(excel) writer which works perfectly if I give the new coordinate attribute (column) a generic name (new_X and new_Y).
I introduced a bulk attribute renamer to add a suffix reflecting the new coordinate system ( for example: X_WGS84 and Y_WGS84) which makes the output more intuitive and will avoid any confusion.

When I do this the dynamic reader changes the order of the output columns to alphabetical.
All the spreadsheets are different, so I don't think I can use a template.
Is there an easy way to achieve this?

2 replies

ebygomm
Influencer
Forum|alt.badge.img+46
  • Influencer
  • January 16, 2026

How are you setting the dynamic schema definition in the writer?


caromc
Contributor
Forum|alt.badge.img+2
  • Author
  • Contributor
  • January 19, 2026

Morning, thanks for you help.

I am setting the dynamic schema defintion to Schema from Schema feature.