Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello.
I need to compare two days and filter the latest date.
OrderNro | Day1 | Day2 |
109555 | 16.10.2017 | 16.10.2017 |
109555 | 16.10.2017 | 9.10.2017 |
109555 | 16.10.2017 | 2.10.2017 |
109555 | 16.10.2017 | 25.9.2017 |
109555 | 16.10.2017 | 18.9.2017 |
109555 | 16.10.2017 | 11.9.2017 |
I need to filter those days thereby that if Day1 is equal to Day 2 only Day 1 value will be shown. Is there Aby load statement to do that on any expression?
BR.
Timo
use if statement in load statement
Like
Load *, if(date1=date2,date1,date2) as new_date
from table;
Regards,