Relationships question - Servicenow

[Anonymous]

Hi all,

I have 3 tables from Servicenow

one is for Assessment questions and it has all the incidents and Request numbers, and also Assignment groups for ONLY incidents instances.

I have another one with SC_Task , that has all the assignment groups for the Requests , as the one of assenstment questions all the REquests are with assignment group as blank

I have tried making a relationship between the id numbers of the first table, and the Req number of the SC_task table, but when i select in the visual the assignment group, it only gives me the Requests assignment groups and not the incidents ones.

How i have to do to have both Incidents and Requests with their assignment groups ?

thanks for your help and i hope my explanation is enough

[Anonymous]

So in summary:

I have assestment table with

incident             assignment group

INC000123        ETO.EESDS.Spain

REQ000123       Empty

And a SC_Task Table

Incident              Assignment group

REQ000123        ETO.EES.DS.France

So i want to achieve

incident               assignment group

INC000123          ETO.EESDS.Spain

REQ000123         ETO.EES.DS.FRance

[v-xicai · Accepted solution]

Hi @Anonymous ,

You can create a calculated table using DAX below.

New table= UNION(
SELECTCOLUMNS('assestment', "Incident",[incident],"Assignment group" ,[assignment group]),
SELECTCOLUMNS('SC_Task', "Incident",[Incident],"Assignment group" ,[Assignment group]))

If you don't need the rows that contain BLANK or empty values, you can filter these values out in Data view.

Best Regards,

Amy

Community Support Team _ Amy

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.