2 Replies Latest reply: Mar 19, 2018 4:50 AM by bhavani b RSS

    Straight Table Null Handling

    bhavani b

      Hi Experts,


      Can any one please help me to resolve the below issue.

      I have three fields named issuenum,Submission Date and Approval Date.

      I have derived Submission Date and Approval Date fields from Name and Value fields with below expressions.


      =  Aggr(Only({<name = {'Submission Date'}>} Value), Value)

      =  Aggr(Only({<name = {'Approval Date'}>} Value), Value)

      Then after I have taken these fields in Straight table Dimensions lbut getting three duplicate rows.

      Is there any way to show these records in one row instead of three rows, in UI. Please help me on this.

      Thanks in advance.