5 Replies Latest reply on Jul 23, 2019 11:34 AM by Sinisa Mikor

    Trying to get different data from worklog and multiple rows for each item,

    bertrand balenguele
      Share This:

      Hi All,

      Let me explain first, I got three kinds of Worklog note that I want have in three different column for each incident in the report,

      I mean column A = Note A, column B = Note B and column C = Note C,

      Note A or B or C depend on Type of work order,

      Want I done is using case when like this, for column A case when Type = Type A then Note A, and so on for other column,

      But maybe du to that I got nothing to put in the else statement I get multiple row for each incident reported,

      In the version that I have Else statement is mandatory,

      I expect some help to avoid multiple rows,

      With regards,

       

       

      Expected

       

      Incident N°Note A
      Note B
      Note C
      0000001dadadadededededididididi
      0000002didididododododudududud

       

       

      Actual

       

      Incident N°Note ANote BNote C
      0000001
      0000001
      0000001dididididi
      0000001dadada
      0000001dededede