How to join same table twice?

How to join same table twice?

  

Hi All,

I have a "Report" table having following columns


Id

CreatedBy

LastModifiedBy

etc..


Column "CreatedBy" and "LastModifiedBy" is User Identifier.

Now I want to display name of CreatedBy and LastModifiedBy in my screen.

So how can I join the same table twice in my aggregate?




Thanks in advance 





Solution

Hi Gopal,

I think you can add the User table twice in your Aggregate.

Let me know if this works, if not i can create a quick example.


Shashank...

Solution

Hello Shashank, 

Thank you very much,

Actually I am dragging and dropping user table again into aggregate. But we can't drag & drop table if it already present.

Then I use "Add source" option to add user table second time and rename it.

It works :)


Thank you Shashank 


Thanks for the feedback Gopal.

I would have told you that since i faced the same issue [was trying to drag it].


Shashank...