Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have 4 status (PFA) . I want to merge 2 status. The status is a field from DB . Is it possible to use any function in expression? or is there any other way ?
Hi,
In the load script you can do it like
Ex:-
LOAD Status,
if(Match(Status,'A','B'),'AB',Status) as NewStatus;
LOAD * Inline [
Status
A
B
C
D ];
Or In front end you can try
if(Match(Status,'A','B'),'AB',Status)
Note:- Check suppress when value is null option.
Regards
Anand
Hi,
In the load script you can do it like
Ex:-
LOAD Status,
if(Match(Status,'A','B'),'AB',Status) as NewStatus;
LOAD * Inline [
Status
A
B
C
D ];
Or In front end you can try
if(Match(Status,'A','B'),'AB',Status)
Note:- Check suppress when value is null option.
Regards
Anand
What do you mean you want to merge them? Do you not want them split up in the chart? If so remove the dimension. If you want to string together 2 fields then do =FieldName1 & ' ' & FieldName2
Cool that was really helpful
FYI Small correction in the front end I need put single quotes for the status for the status I am merging for and AB is the name of the legend name.