This content has been marked as final. Show 3 replies
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).
LOAD * Inline [
Influence, Product, CAMPAIGN
Digital Influence, "METRO", "NULL"
Digital Influence, "WAVE", "NULL"
Help would be appreciated!