Get Single Value from column

[manojkulkarni]

HI Friends,

I have below data, where in I need to get single value from a given column. How can we do this ?

ID	Date	Status
215771	05-02-2016	NEW
215771	05-02-2016	WIP
215771	29-02-2016	PENDING

Expected Out will be

215771	05-02-2016	WIP
215771	29-02-2016	PENDING

[Kushal_Chawda]

can you explain the logic to get the output?

[manojkulkarni]

If you could see the data, on a same day particular task has different status NEW & WIP. I need to get only WIP status in my new table.

Date will have time stamp as well.

[Kushal_Chawda]

How many total status would be there in your data?

[manojkulkarni]

will be 5-6 status

[#6]

Hi Manoj,

Try like this

T1:

load * Inline [

ID, Date, Status

215771, 05-02-2016, NEW

215771, 05-02-2016, WIP

215771, 29-02-2016, PENDING

] Where Status<>'NEW';

may be hope ful for you.

[Kushal_Chawda]

So there will be combination of Status for two dates, so when to consider which status that you need to clerify

[#8]

Hi,

if(Status<>'NEW',Status)

try this once.

Thanks

Tanushree Roy