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

[Community Alums]

Hello Dessai,

You can achieve this by using database view.

Refer the below links may helpful to you.

http://wiki.servicenow.com/index.php?title=Database_Views#gsc.tab=0

Database views

DATABASE VIEWS* for beginners.

Database View - Joined Tables Shows Multiple Same Results

[lSurya 24]

hello ,

you can use Database views

http://wiki.servicenow.com/index.php?title=Database_Views#gsc.tab=0

https://docs.servicenow.com/bundle/geneva-performance-analytics-and-reporting/page/use/advanced_repo...

[adilrathore]

You have the option of creating a new Database to merge data from two tables:

System Definition > Database Views

[imrane]

Thanks for all your answer

But I've already looked for Database Views, but it seems that my question was not clear enough

I want to merge both columns (task_time_worked.task.Incident.CallerId.Company   and   task_time_worked.task.sc_req_item.request.requested_for.Company) in same column in the database view.