Create new field from parse

[cbaqir]

I currently have several fields that have values such as: "CCL: 0.50; ClinDoc: 9.00; Core: 0.25; CPOE: 1.50;"

My script parses out the different solutions and their number so that they can be added up by Solution. I need to be able to create a new dimension that shows which Solutions are applicable to a specific ticket. In this example, I am hoping for a new field called BUILD_SOLUTION that would include CCL, ClinDoc, Core and CPOE as values. Another ticket might have Core, CPOE and Lab. 

I am trying to produce a Mekko chart with Year as a dimension and group by this BUILD_SOLUTION based on the number of hours in each.

[chrismarlow]

Hi,

You can start using SubField to split, so toy application;

data:
LOAD * INLINE [
    TICKET, THING
    A, CCL: 0.50; ClinDoc: 9.00; Core: 0.25; CPOE: 1.50;
    B, CCL: 1.00; ClinDoc: 7.00; CPOE: 2;
 ];

new_data:
LOAD
	TICKET,
	SubField(THING, ';') AS THING2
Resident data;

drop table data;

Returns;

Will then take a bit more work to split THING2 further.

Cheers,

Chris.

[cbaqir · Accepted solution]

I ended up getting what I needed from ValueList. 

[cbaqir]

Thanks but I already have that. I needed to create a synthetic dimension but I figure it out.