How to Sort Two Related Columns in FME Using Custom Classification Without Breaking Row Integrity Colleagues, I'm looking for a way to sort two text columns in Excel based on a custom classification. I have a dataset with several columns, including X, Y, ID Link, GIS Portal Link, Major Company, and Sub Company. My goal is to sort the "Major Company" and "Sub Company" columns according to my own predefined order.Here's what I attempted:I used the AttributeMapper transformer to assign classification values, followed by a Sorter to sort both columns. However, it seems that FME ignored the initial sorting by "Major Company" and only applied the sort to the "Sub Company" column.What I want is: To first sort the "Major Company" column based on my custom classification. Then, within each "Major Company" group, sort the "Sub Company" column based on another classification. It’s important that the row structure remains intact—meaning if a "Sub Company" row is moved, all its related data (X, Y, ID Link, GIS Portal Link) must move with it. However, I worry that "freezing" or locking the
