How to get few fields as separate rows in target in a same file

[Manigandan]

I have Record Identifier, Name, Record Identifier 1, Value coming from input. I want Record identifier and name needs to be written in Row 1 and Record Identifier 1 and Value needs to be written in Row 2. Like as below example. Any idea on how to achieve it?

Record Identifier Name
Record Identifier 1 Value

Thank you in advance!

[koryknick · Accepted solution]

There are a number of ways to do this, but here is a simple example.

Basically, the Mapper creates an array of two objects with two elements for each object (rid and value). Then the JSON Splitter pulls the array apart into one document per array element.
Community 13145 - Split record_2022_08_15.slp (5.2 KB)

The example is self-contained so you can upload it to your org and validate it to see the documents as they move through the snaps for a clearer understanding of how it works.

[Manigandan]

Hi @koryknick ,

You ROCK!!! Its working thank you so much!!

Let me do the remaining mapping.