Categories
Transpose data from rows to columns in FDI
Hi,
Is there a possibility to transpose the data from rows to columns in FDI? How to create a report that displays Previous Assignment and Current Assignment as columns instead of rows?
For example, an assignment column holds all the assignments of an employee and using the assignment end date, I want to create two different columns like previous assignment and current assignment using the same assignment column and show them one beside the other, but the output isn't coming as expected. Can someone help in achieving this please?
Answers
-
@VishnuCh - Welcome to Oracle Analytics Community!
In Fusion Data Intelligence (FDI) you can transpose rows to columns using a Pivot View or by crafting a calculated measure or case-based logic in a table view.Please try using Pivot view first and validate if it helps achieve your requirement.
Hope this helps!
0 -
Hi Sumanth,
Thanks for your response. I already tried using pivot view but the output didn't make sense while looking at multiple employees at the same time, because different employees have different assignments.
Also, when using the case-based logic, output isn't coming as expected, please refer below. I don't want to see those white gaps, I want the assignments to come one beside the other.
If I add filters like previous assignment is not null, then second row entirely goes away and if I do the same for current assignment, then first row entirely goes away.
Is there any other way to achieve this requirement please?
Thank you.
0 -
Hi @VishnuCh
Has your issue been resolved? I'm facing the same problem and would really appreciate it if you could help me out.
0 -
Hi @VishnuCh ,
At first create a dataset out of base columns and then you can create that calculated column ("Previous Assignment") by using LAG function (call it inside Evaluate function) and put "Assignment end date" in Order by clause.
Regards,
Abhirup
0
