Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
Paula1
Creator
Creator

How to change date to date x of this do not sign

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;
Paula Santos
vitória - ES
Labels (2)
2 Solutions

Accepted Solutions
BrunPierre
Partner - Master
Partner - Master

Positives:
LOAD cod,
date,
datex as date,
datex,
not Sign(Status) as Status,
id,
Fabs(qtde) as qtde

Resident Data
Where Status = -1;

BrunPierre_1-1684070197247.png

View solution in original post

3 Replies
BrunPierre
Partner - Master
Partner - Master

Positives:
LOAD cod,
date,
datex as date,
datex,
not Sign(Status) as Status,
id,
Fabs(qtde) as qtde

Resident Data
Where Status = -1;

BrunPierre_1-1684070197247.png

Paula1
Creator
Creator
Author

thanks
Paula Santos
vitória - ES