Want to Create the Field in Data Model

[Anonymous]

Hi i am having the Requirement to add the Dimension in the Ad hoc Report

1.M Comments

2.Scomments

Based on below two column i need to create the (M Comments & S Comments )field in the Data Model

1.A Comments

2.Sub type

Req1: if sub type ='Supliment' ,it should return the relavent A comments -->Need to create it as field .

michaelwad‌loveisfail‌jimhalpert‌afd‌erika‌bgh‌nick2009‌theresaa‌

[olivierrobin · Accepted solution]

hello

why don't you use in your load

if( sub type ='Supliment',[A Comments],other value) as (M Comments & S Comments )