Hi,

According to the documentation 1] the Pivot Field stage creates one record per item in the list or map you are pivoting.

When you pivot a field, the Field Pivoter creates a new record for each first-level item in the list or map.

The list being pivoted in the case of `/requirements` has no items, so no records are created.

Feel free to reply if I did not get the question right or if you are looking for some other functionality, in which case we can look for another pipeline design to achieve it.

<1] https://docs.streamsets.com/portal/platform-datacollector/latest/datacollector/UserGuide/Processors/ListPivoter.html#GeneratedRecords

Thank you for the quick response

I was expecting record with only with non pivoted fields. What is the alternative solution for this situation when list is empty.

If I understood correctly, perhaps we could add another stage to filter out the pivoted fields, and then merge the output records of that stage and the pivot stage like in the following image.

If both stages filter the `/revisions` field you get the following input records in the destination stage:

Is this closer to what you expected? You can find the exported pipeline attached to this message.

Regards

@meghraj was @mikelsr suggestion helpful? If so, Please select  “Best answer” :) 

@meghraj I have made Mikes suggestion the best answer. Thanks of for letting me know!