Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
My data has separated Day and hour(=Zulu), and I need to draw a time series plot with the order of Zulu/Day/Month/Year.
Such an order of 0/01/01/2020 -> 1/01/01/2020 ->2/01/01/2020 and so on..
How can I adjust them at the load editor? or can I combine and adjust them directly and a plot chart?
Year | Month | Day | Zulu | Value |
2020 | 1 | 1 | 0 | 2 |
2020 | 1 | 1 | 1 | 3 |
2020 | 1 | 1 | 2 | 5 |
2020 | 1 | 1 | 3 | 4 |
2020 | 1 | 1 | 4 | 11 |
2020 | 1 | 1 | 5 | 43 |
2020 | 1 | 1 | 6 | 3 |
2020 | 1 | 1 | 7 | 35 |
2020 | 1 | 1 | 8 | 4 |
2020 | 1 | 1 | 9 | 67 |
2020 | 1 | 1 | 10 | 2 |
2020 | 1 | 1 | 11 | 3 |
2020 | 1 | 1 | 12 | 5 |
2020 | 1 | 1 | 13 | 4 |
2020 | 1 | 1 | 14 | 11 |
2020 | 1 | 1 | 15 | 43 |
2020 | 1 | 1 | 16 | 3 |
2020 | 1 | 1 | 17 | 35 |
2020 | 1 | 1 | 18 | 4 |
2020 | 1 | 1 | 19 | 67 |
2020 | 1 | 1 | 20 | 3 |
2020 | 1 | 1 | 21 | 35 |
2020 | 1 | 1 | 22 | 4 |
2020 | 1 | 1 | 23 | 67 |
2020 | 1 | 2 | 0 | 2 |
2020 | 1 | 2 | 1 | 3 |
2020 | 1 | 2 | 2 | 5 |
2020 | 1 | 2 | 3 | 4 |
2020 | 1 | 2 | 4 | 11 |
2020 | 1 | 2 | 5 | 3 |
2020 | 1 | 2 | 6 | 35 |
Hi
Try like below
LOAD *, Dual(Zulu&'/'&MakeDate(Year, Month, Day), NUm(Zulu&Day&Month&Year)) as DateFormat INLINE [
Year, Month, Day, Zulu, Value
2020, 1, 1, 0, 2
2020, 1, 1, 1, 3
2020, 1, 1, 2, 5
2020, 1, 1, 3, 4
2020, 1, 1, 4, 11
2020, 1, 1, 5, 43
];