Straight Table Null Handling

[bhavvibudagam]

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.

[nagaiank]

You may try the following:

NewTable:

NoConcatenate

load issuenum, Concat([Submission Date],'') as [Submission Date],Concat(Approval,'') as Approval

resident (your original table name here)

group by Iisuenum;

Drop Table (your original table name);

[sunny_talwar · Accepted solution]

All three of them are coming as a dimension? May be this?

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

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