Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everybody,
In the project attached I got 2 tables named "Date" and "Heure" (from XML file). The problem is that I get many times the same date in the field "Date". What I would like to get is to clik on one date and get all "heure" of this "date". In fact I don't want the same value in "Date".
Thank you very much
Use following to load date field. The problem is that the date field is actually a timestamp field and with time, they are unique values. With daystart function, if takes 00:00:00 as the time so you get same dates (of same time).
LOAD
Date(daystart(date)) as Date,
....
Use following to load date field. The problem is that the date field is actually a timestamp field and with time, they are unique values. With daystart function, if takes 00:00:00 as the time so you get same dates (of same time).
LOAD
Date(daystart(date)) as Date,
....