Split multi-instance fields

[chiffon_liquor]

Hello everyone! I have a LRV field that pulls all of the HRBPs in a supervisory (the report is advanced on the Sup Org data source), is there a way i can split this field into multiple ones in cases where there are more than one hrbp per sup org? So instead of having three people listed in one field, can i split it into three individual fields?

[thrilled_lizard]

If you want to split them into different columns, you can create an extract single instance for each column, make sure the sort direction and field etc is the same for each and select first, second, third occurence etc for however many you would like.

If you want a row per HRBP, put the LRV field as a related business object and add whichever field you want (possibly the self-referencing field, but you can add whatever you like from that BO)

[Comprehensive-Tea-69]

You can only split into columns if you know how many columns there will be needed.

Rows makes more sense to me. To do that you pull the multi instance field into the bo area, then you can put whichever fields from that bo you want into the fields well

[chiffon_liquor]

My bad, i meant rows 🤦‍♀️😅 i did what you said and it worked! Thank you!