Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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)
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);
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)