How to create a filter where the particular column doesnt exist?

[nishanthi_8]

I dont have a column called status which consists of whether the employee has been assigned or not - assigned to Project. But i explicitly want to create a column from script side as Status - Assigned / Not - Assigned as a filter and once it is selected the Particular name should be displayed. How it can be achieved? I tried with the mapping load it gives the names of assigned. But I dont want in that case. Instead i want the filter to contain to assigned and not assigned and based on that selection particular name should be displayed.

[Anonymous]

Create a inline field like this:

Load * Inline

[Status

Assigned

Not Assigned

];

Use it as a filter at front end and make the data conditional to display

[nishanthi_8]

any other alternative method ?

[Anonymous]

I think Inline is the best option for same

[#5]

Or if you can write IF condition in your script: IF(cond, 'Assign','Not Assign') As Status

[oscar_ortiz]

You can try an if statement in your script.

Something like:

If( [ Your Condition], 'Assigned', 'Not Assigned' ) as Status