Split a field

[VijaySrrie]

Hi,

I have 4 different correlation ID's in same row, I want to split them and place it in single row

1aaaaa-2bbbb-3cccc-4dddd 5aaaa-6bbb-7ccc-8ddd 1eeee-2ffb-3cggc-4dhhd 5aiia-6jjb-7kkc-8lld

[ITWhisperer · Accepted solution]

It looks like you need to split by " " to create a multi-value field, then mvexpand the field to put them on separate rows.