Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Brun Pierre, helped me with this script. But failed to change date to datax
cod | date | datex | Status | id | qtde |
2360 | 11/12/2012 17:33 | 15/12/2012 17:33 | -1 | 201221 | -24 |
2360 | 11/12/2012 17:33 | 15/12/2012 17:33 | -1 | 201222 | -84 |
2360 | 11/12/2013 17:38 | 15/12/2013 17:38 | -1 | 201228 | -24 |
2360 | 11/12/2013 17:38 | 15/12/2013 17:38 | -1 | 201227 | -84 |
How do I change date to datax in this script that is correct.
Desired result.
cod | date | datex | Status | id | qtde |
2360 | 12/11/2012 17:33 | 15/12/2012 17:33 | -1 | 201221 | -24 |
2360 | 12/11/2012 17:33 | 15/12/2012 17:33 | -1 | 201222 | -84 |
2360 | 12/11/2013 17:38 | 15/12/2013 17:38 | -1 | 201228 | -24 |
2360 | 12/11/2013 17:38 | 15/12/2013 17:38 | -1 | 201227 | -84 |
2360 | 15/12/2012 17:33 | 15/12/2012 17:33 | 0 | 201221 | 24 |
2360 | 15/12/2012 17:33 | 15/12/2012 17:33 | 0 | 201222 | 84 |
2360 | 15/12/2013 17:38 | 15/12/2013 17:38 | 0 | 201228 | 24 |
2360 | 15/12/2013 17:38 | 15/12/2013 17:38 | 0 | 201227 | 84 |
Correct script just need to handle date to datax
Data:
LOAD id,
date,
datex,
status,
ordem,
qtde
FROM SourceTable;
Positives:
LOAD id,
date,
datex,
not Sign(status) as status,
ordem,
Fabs(qtde) as qtde
Resident Data
Where status = -1;
Positives:
LOAD cod, date,
datex as date,
datex,
not Sign(Status) as Status,
id,
Fabs(qtde) as qtde
Resident Data
Where Status = -1;
Positives:
LOAD cod, date,
datex as date,
datex,
not Sign(Status) as Status,
id,
Fabs(qtde) as qtde
Resident Data
Where Status = -1;
thanks