Merging Data from two (or more) table into one table

[imrane]

Hi everyone,

I use [task_time_worked]   to track time worked on Incident and RITM

I want to make a report "group by company"

But Company is not at the same place for both tables :

• In Incident : task_time_worked.task.Incident.CallerId.Company
• In Sc Req Itm : task_time_worked.task.sc_req_item.request.requested_for.Company

What I want to achieve : Having a table that is like this

Created (from task_time_worked)	Time Worked	User (form task_time_worked)	Task Type	Company (from incident AND req_item)
20/08/2017	15min	IDE	Inc	Cust1
20/08/2017	15min	IDE	Req_Item	Cust1

In other word, I think I want to make a Union where I can use a "AS Company"

Do you have any clue or advice ?

Thanks a lot

[imrane · Accepted solution]

Hi everyone,

I finally gave up.

I used a "scripts - background" to fill "compagny" using rules listed above for all Incidents and Requested Item.

I used a Business Rule to fill "company" automatically

I can now report on task.company as wanted