combining two fields to one

[#1]

Hi,

My requirement is I have two fields X,Y. X field has  values A,B and Y field has value C..now I want to create a new field Z with values A,B,C. My intention is to create graphs on combined values A,B and C.

Any help is highly appreciated.

[MayilVahanan]

HI

Try like this

test:

LOAD * Inline

[

State,region

Ca,West

NY,East

TX,South

];

Load if(wildmatch(State,'C*'),SubField(State&','&region,','),State) as Z Resident test;