topic Re: Create new field using loaded field in App Development

Create new field using loaded field

Anonymous — Wed, 08 Nov 2017 13:14:08 GMT

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

Re: Create new field using loaded field

sunny_talwar — Wed, 08 Nov 2017 13:41:01 GMT

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

Re: Create new field using loaded field

Anonymous — Wed, 08 Nov 2017 16:37:07 GMT

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

Re: Create new field using loaded field

sunny_talwar — Wed, 08 Nov 2017 16:43:19 GMT

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?

Re: Create new field using loaded field

Anonymous — Thu, 09 Nov 2017 13:04:34 GMT

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

Re: Create new field using loaded field

sunny_talwar — Thu, 09 Nov 2017 13:13:07 GMT

Ya, does that work?

Re: Create new field using loaded field

Anonymous — Thu, 09 Nov 2017 13:28:25 GMT

Thanks it works Sunny !