Grouping data and transpose reading from vertical to horizontal doesn't work

[cppong]

Need some help. I have the source like below picture (INPUT) and I would like to Grouping same data attribute (column FW, WF) and transpose reading (Median calculate from Param1, Param2 for each group of FW, WF) from vertical to horizontal data like picture output.

I used Read CSV → Grouping (node GroupBy)—> Transpose but it doesn’t work.

Anyone expert please help.

Thanks a lot sir.

[takbb]

Hi @cppong ,

Try the Unpivot node. Specify the “value columns” as Param1 and Param2, and the “retained columns” as FW and WF.

As you first want the median, I think you would first perform your GroupBy to calculate the Medians for Param1 and Param2, grouped by FW and WF as I presume you are already doing, and THEN apply the Unpivot .

Unpivot

You may need to resort / rename columns after to match your required output, but it should give you the right basic format you require.

[cppong]

Hi takbb, I followed your answer. So I can solved the problem now. It very fantastic ! I never know this before!
Anyway, thank you very much again for helping me.