condition

[master_student]

Hello Guys,

I wanna transform this table into conditions (a calculated dimension):

if provider_group ='Mailin' and criticte='Critique' and segment =VLV or segment='LV' then SLA=1440

and so on

Provider Group	Criticité	Segment	SLA
MAILING	Critique	VLV	1440
MAILING	Critique	LV	1440
MAILING	Critique	MV	1440
MAILING	Critique	HD	1440
MAILING	Critique	HV	1440
MAILING	Critique	Premium	1440
MAILING	Critique	LowEndUser	1440
MAILING	Critique	HighEndUser	1440
MAILING	Critique	Entreprise	1440
MAILING	Critique	One to one	1440
MAILING	Non Critique	VLV	4320
MAILING	Non Critique	LV	4320
MAILING	Non Critique	MV	4320
MAILING	Non Critique	HD	4320
MAILING	Non Critique	HV	4320
MAILING	Non Critique	Premium	4320
MAILING	Non Critique	LowEndUser	2880
MAILING	Non Critique	HighEndUser	2880
MAILING	Non Critique	Entreprise	2880
MAILING	Non Critique	One to one	1440

thanks

[Anil_Babu_Samineni · Accepted solution]

Perhaps this?

If([Provider Group] = 'MAILING' and Criticité = 'Critique' and (Segment = 'VLV' or Segment = 'LV') and SLA = 1440, 1,0)

OR

If([Provider Group] = 'MAILING' and Criticité = 'Critique' and (Segment = 'VLV' or Segment = 'LV'), 1440)

[Anonymous]

that way you can import the fieldnames into your table by creating a column for each name..maybe that helps

tab:

LOAD [Provider Group],

     Criticité,

     Segment,

     [               SLA]

FROM

test.xlsx

(ooxml, embedded labels, table is Sheet1);

let vS='';

for i= 1 to NoOfFields('tab')

map:

mapping LOAD

$(i) as map_field,

fieldname($(i),'tab') as campo

AutoGenerate 1;

let vStringa=concat(fieldname($(i),'tab'),'-');

left join(tab)

LOAD *,

ApplyMap('map',$(i)) as field_$(i)

Resident tab;

NEXT

[sunny_talwar]

What do you mean a calculated dimension... what is SLA= 1440 means here? and "so on" how do you expect us to interpret that