Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
What exactly are you trying to do? Can you share some data to show what you have and what you intend to do?
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
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?
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
Ya, does that work?
Thanks it works Sunny !