Help with merge - Servicenow

[Anonymous]

Hi all

I hope you are familiarized with Servicenow .

I have two tables :

Assestment instance question

SC_task

in Assessment one, i have all the request numbers and all the incident numbers, but only incidents have the assignment group.

the SC_task one, have all the assignment group for requests

what I have done is merge queries assessment instance question and SC_task with the column of incidents and requests from assessment and Requests from SC_task.

in the new column I have already the assignment groups for tasks, but the assignment groups for incidents are null.

How can I copy the assignment group of incidents to the new column to have in this column all assignment groups of Requests and incidents

Thanks!!

[TomMartens]

Hey @Anonymous ,

if you are using DAX, you can consider the DAX function LOOKUPVALUE to pull the group from the table SC_task. Using IF can help to create a single column that hosts the groups for incidents and requests.

Hopefully this provides you with some new ideas.

Regards,

Tom

[Anonymous]

@TomMartens  , thanks i think it would work but i am really rookie with DAX, if the table with the name i want to fill the name is assestment table, and the one with nulls that i want to fill with the values of assestment table, is named sc_task table, how would be the DAX? should i create a new column first?

so sorry for all the questions!!!

[TomMartens]

Hey Crecis,

please creae a pbix that contains sample data for both tables, upload the pbix to onedrive or dropbox and share the link. If you use Excel to create the sample data, upload the xlsx as well.

Regards,

Tom

[Anonymous]

@TomMartens  , let me know if you can download from my drive

https://drive.google.com/open?id=1xpjUyLjeGJoHHgNfTnibBMGJA_dDOxiE 

[v-joesh-msft]

Hi @Anonymous ,

You can create a calculated column like the following:

Column =
IF (
    LOOKUPVALUE (
        SC_task[assignment_group],
        SC_task[request], 'Assestment instance question'[Task]
    )
        = BLANK (),
    [Assignment group],
    LOOKUPVALUE (
        SC_task[assignment_group],
        SC_task[request], 'Assestment instance question'[Task]
    )
)

Here is a demo, please try it:

https://qiuyunus-my.sharepoint.com/:u:/g/personal/pbipro_qiuyunus_onmicrosoft_com/EZWrM7QOAZNKqIQ6t8jjxloBRcIe3RJfNrEode_qGQJZ7A?e=B3izxj

Best Regards,
Community Support Team _ Joey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.