Column sorting after pivoting

KNIME Analytics Platform
1

Hi, i’m new to Knime.
I did a pivoting and the column is aggregated by Month+Vol and Month+NS.
2022-01 vol, 2022-01 NS, 2022-02 vol, 2022-02 NS, 2022-03 vol, 2022-04 NS

I’d like to sort it as
2022-01 vol, 2022-02 vol, 2023 vol, 2022-01 NS, 2022-02 NS, 2022-03 NS

any idea? Thanks.

1 Like
2

Hello @CCCCH and welcome to the KNIME forum.

You can proceed in manual way with Column Resorter node. Or more in a more authomatized way, by feeding it with column headers sorting in Reference Column Resorter node.

BR

4 Likes
3

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.