specific day

[soniasweety]

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?

[its_anandrjs]

If you have any date field then try this

Load

*

From Source where WeekDay(DateField) = 'Sat';

[Anil_Babu_Samineni]

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';

[its_anandrjs]

Another way also on UI you can do this if you have day field

Sum( {<Dayfield = {'Sat'} >} Sales)

[soniasweety]

I have a  weeknumber  column in DB and I want to load last 10 weeks data of Saturday's ?

is it possible?

[its_anandrjs]

What type of data it has num or string.

[soniasweety]

Numbers only

weeknumber

36

35

34

33

32   like that

[its_anandrjs]

Try this with where condition

Table1:

Load

*

From Source Where WeekDay(DateField) >= Max(weeknumber) - 10  and WeekDay(DateField) <= Max(weeknumber);

[soniasweety]

Okay Anand thanks I will try and update on the same