Need to merge two status

[#1]

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 ?

[its_anandrjs · Accepted solution]

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

[pho3nix90]

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

[#4]

Cool that was really helpful

[#5]

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.