Sign up to take part
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
i want to create column in pivot recipe with specific sorting ,any idea how to do it
example:
col1 | col2 |
national | fail |
international | success |
national | success |
international | fail |
pivot
national_success,national_fail,international_success,international_fail
so pivot table column col1 ,col2 sorted desc
Hi @debanasser1,
The pivot recipe needs more than 2 columns. Can you give an example of the output that you are looking for?
i want to create column in pivot recipe with specific sorting ,any idea how to do it
example:
a | b | col1 | col2 |
1 | 23 | national | fail |
1 | 34 | international | success |
2 | 44 | national | success |
2 | 44 | international | fail |
pivot
national_success,national_fail,international_success,international_fail
so pivot table column col1 ,(col2 sorted desc )
row identifier : a
values: sum of b