Get Record Producer variable in columns

snow34
Tera Contributor

‎08-22-2023 05:56 AM - edited ‎08-22-2023 05:57 AM

I have created a database view where i am joining question_answer table and incident table , with the help of this database view i am able to get all the variables from record producer . but for each variables there is a row , i want my variables in column . so that for one incident number there will be only one row.

Preview file
45 KB
0 Helpfuls
  • 365 Views
1 REPLY 1

Karthiga S
Kilo Sage

‎08-22-2023 06:43 AM

Hi @snow34 

 

Please find the thread https://www.servicenow.com/community/itsm-forum/how-to-a-add-record-producer-variable-to-the-list-vi... 

 

Post adding the variable in the respective view,  export the data.

 

Please mark it Correct and Hit Like if you find this helpful!

 

Regards,

Karthiga

0 Helpfuls