Grouping Dimensions - Multiple Fields

[Anonymous]

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

[alexantone]

hello

I wish you could try with a mapping and an apply map on the resident table?

[Anonymous]

Hi Alexandre,

sorry, could you provide an example of this?

[ychaitanya]

What is the problem that you are having with the Current Approach of having Inline load with those 3 field names ?

you can use the Nested IF Statements for multiple conditions to derive the dimension (influence)  as well right ?

Thanks

CY