Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I want to load the data from database only Saturday's data
how can I load this?
can anyone give the syntax of it?
If you have any date field then try this
Load
*
From Source where WeekDay(DateField) = 'Sat';
These?
Load * From Table Where Match(WeekDay(FieldName), 'Sat');
OR
Load * From Table Where WeekDay(FieldName) = 'Sat';
OR
Load * From Table Where WeekDay(FieldName) Like 'Sat';
Another way also on UI you can do this if you have day field
Sum( {<Dayfield = {'Sat'} >} Sales)
I have a weeknumber column in DB and I want to load last 10 weeks data of Saturday's ?
is it possible?
What type of data it has num or string.
Numbers only
weeknumber
36
35
34
33
32 like that
Try this with where condition
Table1:
Load
*
From Source Where WeekDay(DateField) >= Max(weeknumber) - 10 and WeekDay(DateField) <= Max(weeknumber);
Okay Anand thanks I will try and update on the same