Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 |
can you explain the logic to get the output?
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.
How many total status would be there in your data?
will be 5-6 status
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.
So there will be combination of Status for two dates, so when to consider which status that you need to clerify
Hi,
if(Status<>'NEW',Status)
try this once.
Thanks
Tanushree Roy