Avatar

Correct answer by
Community Advisor

Hello @madisonditullio,

you can do it but with use of split

  • Use Split activity
  • Set up your workflow like so: all Subset going to empty java script activity used here as flow through

MarcelSzimonisz_2-1628264269114.png

 

  • Add segment code to each subset of a split

MarcelSzimonisz_1-1628264227488.png

  • In delivery 'Object modification' script add

 

 

 

 

  var getSegmentName = function(name){
    if( name === undefined)
      logError("Argument 'name' is required."); 
    
    try{
      var res = sqlSelect("targetData,@" + name + ":string",
          "select " + name + " from " + vars.tableName + " GROUP BY " + name);
      return res.targetData[0]['@'+ name].toString();
    }catch(e){
      logWarning("Segment name '" + name + "' does not exist in the targeting table.");
      return false;
    }
  }
  
  delivery.deliveryCode = delivery.deliveryCode + '_' + getSegmentName('sSegmentCode'); 
  
  logError(delivery.deliveryCode);

 

 

 

 

@segmentCode is in SQL temporary table saved as sSegmentCode

 

 

 

Result:

MarcelSzimonisz_0-1628264954845.png

 


Enjoy!

 

Marcel

 

View solution in original post