I followed the steps in Example 2 here to switch my table columns to rows: https://community.safe.com/s/article/transpose-a-table-using-fme
Is there a way to keep the original column order as the new row order after the table is transposed?
Using the counter/sorter, as outlined in the example does not give me the desired order of rows.
@mzondervan The new SchemaScanner transformer should be able to help here. It preserves the order of the attributes in the attribute{} list. You can then merge this back onto the transposed records. I've attached an example workspace (FME 2022.1)
@mzondervan The new SchemaScanner transformer should be able to help here. It preserves the order of the attributes in the attribute{} list. You can then merge this back onto the transposed records. I've attached an example workspace (FME 2022.1)
Thank you, much appreciated.