Transpose data from rows to columns in FDI

Question

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?

Abhirup Nayak · Answer

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

Sai Poorna · Answer

Hi @VishnuCh

Has your issue been resolved? I'm facing the same problem and would really appreciate it if you could help me out.

VishnuCh · Answer

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.