pivot recipe

Options
debanasser1
debanasser1 Registered Posts: 6

i want to create column in pivot recipe with specific sorting ,any idea how to do it

example:

col1 col2

national

fail
internationalsuccess
nationalsuccess
internationalfail

pivot

national_success,national_fail,international_success,international_fail

so pivot table column col1 ,col2 sorted desc

Answers

  • Catalina
    Catalina Dataiker, Dataiku DSS Core Designer, Registered Posts: 135 Dataiker
    Options

    Hi @debanasser1
    ,

    The pivot recipe needs more than 2 columns. Can you give an example of the output that you are looking for?

  • debanasser1
    debanasser1 Registered Posts: 6
    Options

    i want to create column in pivot recipe with specific sorting ,any idea how to do it

    example:

    abcol1 col2

    1

    23

    national

    fail
    134internationalsuccess
    244nationalsuccess
    244internationalfail

    pivot

    national_success,national_fail,international_success,international_fail

    so pivot table column col1 ,(col2 sorted desc )

    row identifier : a

    values: sum of b

Setup Info
    Tags
      Help me…