Question

Ordering table rows after transposing


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.

 

 


2 replies

Badge +2

@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.

Reply