How to split Multi-Row Variable Set rows into multiple RITMs for a single Request?

[VishwamitraM]

Hi Community,

I have a requirement related to catalog items with a Multi-Row Variable Set (MRVS).

Currently, when a user submits a catalog request that includes multiple rows in the MRVS, ServiceNow creates:
• One Request (REQ), and
• One Request Item (RITM),
with all MRVS rows stored under that single RITM in the sc_multi_row_question_answer table.

Requirement:
For one Request (REQ), I need to generate multiple RITMs — essentially, one RITM per MRVS row.

Example:
• If the MRVS contains 2 rows (e.g., two different order items),
• Then I want the system to create 2 RITMs under the same Request, instead of 1 RITM containing both rows.

Question:
• Is there a standard way to achieve this in ServiceNow?

I’d appreciate any guidance, best practices, or examples from anyone who has implemented this before.

Thanks in advance!

[Ankur Bawiskar]

@VishwamitraM 

It should work fine.

I believe I answered your question with approach and you can enhance it further based on your requirement and developer skills.

If my response helped please mark it correct and close the thread so that it benefits future readers.

[VishwamitraM]

Hi Ankur,

I tried the approach suggested by you, but when the new RITM records are created, they have all the variable rows in it. I want that each RITM record should be generated for each row.

Please guide.

Regards,

Vishwamitra Manav

[Ankur Bawiskar]

@VishwamitraM 

that was not mentioned in your original question.

I already answered your original question and already informed that you will have to enhance it based on your requirement.

If my response helped please mark it correct and close the thread so that it benefits future readers.

[VishwamitraM]

Hi Ankur,

I have mentioned :

For one Request (REQ), I need to generate multiple RITMs — essentially, one RITM per MRVS row.

Regards,

Vishwamitra Manav

[Ankur Bawiskar]

@VishwamitraM 

that's what the approach I shared.

Example: If MRVS has 4 rows, it will create 4 RITMs and then update the REQ of these 4 RITMs with parent REQ

Now your requirement is for each RITM only show that respective MRVS Row, for that you can always enhance and ensure only that MRVS row is included in the MRVS variable for that RITM

If my response helped please mark it correct and close the thread so that it benefits future readers.