July 19, 2016, 03:42 PM
hainguyen[CLOSED]Move data up when there is null data using ACROSS
Hi all,
I need help in this case:
My code is
TABLE FILE SQLOUT
PRINT
BATCH_TIME AS 'TIME'
BATCH_GRADE AS 'GRADE'
ACROSS REACTOR
END
The output is:
REACTOR
R601 R604 R308
TIME GRADE TIME GRADE TIME GRADE
2016/06/01 K38
2016/06/01 K36
2016/06/02K35
2016/06/03 K38
2016/06/04 K36
Record of each reactor is displayed in each line. How can I move these records go up so it can fill the blank lines like below:
REACTOR
R601 R604 R308
TIME GRADE TIME GRADE TIME GRADE
2016/06/01 K38 2016/06/01 K36 2016/06/02 K35
2016/06/03 K38 2016/06/04 K36
Thanks in advance.
This message has been edited. Last edited by: <Emily McAllister>, July 19, 2016, 07:57 PM
Dan SatchellReplace PRINT verb with SUM, or add SET ACROSSPRT = COMPRESS before the TABLE request.