View is changed

sasidharp
Level 3
View is changed

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

 

0 Kudos
1 Reply
fchataigner2
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

0 Kudos