split dimension

[josemaria_cabre]

Hi,

I have a table with this structure

Reference	Type	From	To	Level	Code
0010	02	06/04/2018 0:00	06/04/2020 0:00	L2	578060,578311

How do I split dimension "code" in script, having this table as result? (1 row per Code coincidence)

Reference	Type	From	To	Level	Code
0010	02	06/04/2018 0:00	06/04/2020 0:00	L2	578060
0010	02	06/04/2018 0:00	06/04/2020 0:00	L2	578311

Thanks in advance for your help, 
Jose.

[Taoufiq_Zarra · Accepted solution]

Maye  be

Data:

LOAD Reference, Type,"From", To, Level,subfield(Code,',') as Code INLINE [
    Reference, Type, From, To, Level, Code
    0010, 02, 06/04/2018 0:00, 06/04/2020 0:00, L2, "578060,578311"
];

[josemaria_cabre]

Worked perfect!

Thanks for your help Taoufiq!

Best regards,
Jose