Transform a table

Hello everybody,

I want to transform a table as shown in the attached picture. I marked the header in gray. The Value is an Integer (0 or 1). On the left side is the current table. On the right side the new tabel I want to create.

Does anyone have an idea how to do it?

Best regards!

Hi @Phibu,

This can be easily done by using the Pivoting node.

Select the “ID” as the grouping column, “Measurepoint” as the pivot and “First” as the aggregation method for the “Value” column.

:blush:

5 Likes

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