I have following table:
Height value Height limit Height Result Length value Length limit Length Result
10 11 12 13 14 15
I want to transform it into:
Value Limit Result
Height 10 11 12
Length 13 14 15
I have Unpivot it and now I have table like this
column Val
Height value 10
Height limit 11
Height Result 12
Length value 13
Length limit 14
Length Result 15
Not sure how to proceed further. Any help will be much appreciated
refering to your question I recommend
1st) Split the column “column” to get Parametername and -type in seperate columns e.g.
Column 1: Height
Column 2: value
Column 3: 10
then use
2nd) pivot node with “Column 1” as group condition, “Column 2” as pivot condition and “Column 3” as aggregation type with aggregation option first.
Sorry, I forgot to mention there are multiple rows like :
Height value Height limit Height Result Length value Length limit Length Result Line
10 11 12 13 14 15 1
16 17 18 19 20 21 2
22 23 24 25 26 27 3
and I don’t want to aggregate those, I want output to be like
Hi,
in this case add math formula node and return the rowindex before you use the unpivoting node. For unpivoting keep the rowindex column as retained and in the pivoting node as group condition.
