Create new field using loaded field

[Anonymous]

Hello Guys,

I needed help ....

My question is :- I have a field loaded from qvd file with all the options in it. 

For ex:- Status field which has options such as lost , win , cancelled , transferred and so on

I have used 3 options using where clause .

Now I want to use the same field (''Status'') with remaining 3 options  and dont want to alter the first 3 selected options .

I want a new field that should show remaining options if i pull it in datasheet .

How do i do this . Kindly help me with this 

[sunny_talwar]

What exactly are you trying to do? Can you share some data to show what you have and what you intend to do?

[Anonymous]

Thanks Sunny for your reply !

Yes Sure

[Project0]:

  LOAD Distinct

   '' Status '',

FROM Project.qvd

where  ( Status = 'Lost ' or Status = 'win ' or Status ='cancelled'));

Status field has few other options such as Delayed , Past, Postponed    and so on ...

So i want to create a new field with these remaining options .

Thanks,

ravi

[sunny_talwar]

The new field will be called Status_Other? and those will be concatenated to your table above? So, each row will either have Status or Status_Other?

[Anonymous]

Thanks for your reply !

Yes so you mean something like this :-  ?

concatenate

[Project2]:

LOAD

    Status as Status_Other

where (Status = 'Delayed  ' or Status = 'Past' or Status ='Postponed   '

basically what i want is new column in data sheet like this :-

Status_other

Delayed

Past

Postponed

Thanks,

Ravi

[sunny_talwar]

Ya, does that work?

[Anonymous]

Thanks it works Sunny !