3 Replies Latest reply: May 14, 2018 7:55 PM by chaitanya yelisetty RSS

    Grouping Dimensions - Multiple Fields

    Shay Khosrow

      Hi all,

       

      I am trying to achieve a grouping of a dimension with multiple rules. I am basically trying to create a new grouped dimension (influence) which has a field (Digital Influence). This digital influence field will be made up of pick up all values when the product name is "Metro" or "wave" and the campaign code field is empty.

       

      So far I have tried multiple versions of the following script. Loading an Inline table with the new field name (influence) and two existing fields (product and campaign).

       

      Programmes2:

      LOAD * Inline [

      Influence, Product, CAMPAIGN

       

      Digital Influence, "METRO", "NULL"

      Digital Influence, "WAVE", "NULL"

       

      ];

       

      Help would be appreciated!

       

      Thanks,

       

      Shay