Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello All ,GM
I trying to sort Bucket Column based upon Bucket Date at backend (Scripting),the syntax I have written is
Dual(Bucket,num(date(Timestamp#(Bucket_Date, 'MM/DD/YYYY hh:mm:ss'), 'YYYY/MM/DD' ))) as [Bucket],
output :
If we observe the above table the Values in the Bucket Column(3rd) suppose to be as same as the test_Bucket column but what I am getting is wrong
Please suggest what change do I need to do in the dual Syntax or can we sort the bucket with any other syntaxs
Thanks
I don't see any issue with the syntax , please check on the expression results , I feel it is giving he null/blank output
BucketDate needs to be to correspond with the multiple values from Bucket - but this doesn't happens here. Regarding to your screenshot you have two different dates and therefore you get two different string-values from Bucket.
This means you couldn't use BucketDate as numeric value within the dual(). Maybe you could use another field and/or creating with recno(), rowno() and/or autonumber() in any combination an unqiue field-value. Another approach might be to load the relevant tables and/or fields-combinations with your wanted sort-order.
- Marcus