View is changed

sasidharp
sasidharp Registered Posts: 27 ✭✭✭✭

While i am preparing a data after pivoting it displayed like this

preco.JPG

After the run, the data is displayed in this way

procop.JPG

 I need the the values to be dispalyed in one row as displayed in the recipie. can someone help with it

Answers

  • fchataigner2
    fchataigner2 Dataiker Posts: 355 Dataiker

    Hi,

    the pivot processor outputs one row per input row, so the display in the design mode of your prepare recipe indicates that the first processor (remove kpi) removed all rows but one.

    In any case, after a pivot recipe, if you want to re-group rows by some subset of the columns, you need to use a Group recipe

Setup Info
    Tags
      Help me…