Split comma separated value then display to report

arisadriano
Tera Contributor

hi there,

 

We have a report requirement to split the values of a comma separated field and then display it to a report.

For example, data in servicenow looks like:

NumberAffectedCI
INC00123

CI1, CI2

 

We want to create a report that shows this instead:

NumberAffectedCI
INC00123CI1
INC00123CI2

 

Is this possible?  Thank you for your help.

0 REPLIES 0