Getting the label of a split subset per delivery in data extraction

[brianp76764507]

Hi everyone,

I'm working on an automated report and one of the fields I'm trying to pull is the label of the split subset the delivery is attached to. This is what I have right now in the Data Extraction activity: 

In the picture below for example, I would be trying to get the values 'Engaged' and 'LowEngaged' for Delivery 1 and Delivery 2.

The expression above that I'm currently using just returns the label of first subset for every delivery. I've tested this on other campaigns with more than 2 subsets and they all just return the same label.

What I'm getting:

Delivery Label	Subset Label
Delivery Template 1	Engaged
Delivery Template 2	Engaged

What I want to get:

Delivery Label	Subset Label
Delivery Template 1	Engaged
Delivery Template 2	LowEngaged

Is there an expression I can use to achieve this or is this going to require a JS solution? Any help is appreciated.

Bonus Question:

Can this technique be applied to cases where there's more than 1 split?

In this case is there a way to return something like:

• "Engaged, Travel2"
• "Engaged, Travel"
• "LowEngaged, Travel2"
• "LowEngaged, Travel"

Again, any help is much appreciated.

Thanks.

[Jonathon_wodnicki · Accepted solution]

Hi,

The answer to both questions is to use js; get the workflow's data clob then parse it for transitions, i.e.:

for each (var extract in workflow.activities.extract) {
  for each (var transition in extract.transitions.*) {
    // make use of transition.@label, transition.@target
  }
}

Thanks,

-Jon

[brianp76764507]

Thanks Jon, apologies for bothering you but I'm not super familiar working with javascript in the context of pulling values from Campaign. Is there a resource I reference or some sample code? I tried figuring it out on my own and haven't had much luck. Thanks again for your help!

[Jyoti_Yadav]

Hi,

If your split is one time configuration, you can do JS variables in Advanced tab of split.

Js you can use:

vars.split1="Engaged"

vars.split2="Low Engaged"

And then you can use these variables in your delivery as: <%=vars.split1%>

Thanks.