Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I tried order by date and it's not working is there any other way to sort that column.
Eg.
LOAD Name,Address,Birthday
Resident Details
Order By Name,Birthday desc;
I want the table to load the latest date data first.
Birthday format is in DD/MM/YYYY
Thank you.
Try this
LOAD Name,Address,Birthday
Resident Details
Order By Name,Num(Birthday) desc;
LOAD Name,Address,Date(Birthday) as Birthday
Resident Details
Order By Name,Date(Birthday) desc;
Hi angellineeee,
at first please check that your DateFormat is set correctly in your load script.
In our case it should be:
SET DateFormat='DD/MM/YYYY';
Otherwise try:
LOAD Name,Address,Date#(Birthday, 'DD/MM/YYYY') as Birthday
Resident Details
Order By Name,Date#(Birthday, 'DD/MM/YYYY') desc;
regards
Marco
Hi,
I think you need to format the date like this before ordering, currently your date field is considering as string.
Eg.
LOAD Name,
Address,
Date(Date#(Birthday, 'DD/MM/YYYY')) AS Birthday
Resident Details
Order By Name, Date#(Birthday, 'DD/MM/YYYY') desc;
Regards,
Jagan.
is it right to order by name, birthday?
This means each name has different birthday which need to be ordered.
Regards