Hi !
I am trying to order one column (batches) by values of a numeric date column but am getting an issue where when two different batches were manufactured on the same day.
For example, why would this not order correctly?
dt = New Table("table",
Add Rows(10),
Compress File When Saved(1),
New Column("Text",
Character,
"Nominal",
Set Values({"A", "B", "C", "D", "E", "F", "AA", "BB", "CC", "DD", "EE", "FF"})
),
New Column("Level",
Numeric,
"Continuous",
Format("Best", 12),
Set Values([1, 2, 2, 3, 3, 4, 5, 6, 7, 8, 9, 10])
)
);
The order of the text column would be the following:
text level
A 1
B 2
D 3
F 4
AA 5
BB 6
CC 7
DD 8
EE 9
FF 10
C 2
E 3
Instead of the desired:
text level
A 1
B 2
C 2
D 3
E 3
F 4
AA 5
BB 6
CC 7
DD 8
EE 9
FF 10
C 2