How to split a multivalue field for a data model/pivot table to treat each field value separately?

[spammenot66]

I have a field states, which is delimited by |. For example states=NY|VA|MO|GA
I'm able to get it to expand and treat each as a seperate value:

dedup states | table states | makemv delim="|"  states| mvexpand states|...

How do I do this within a data model and force it to treat each state as a separate value in these scenarios?

[ajayabburi508]

|eval states=split(states,"|") |mvexpand states | field states