Load only weekdays

[Anonymous]

Hi,

I have the following script

LOAD Date, Name, Value

WHERE Weekday(Date) = true ;

I only want the dates that occurs on weekdays.

Any assistance is appreciated.

Kind Regards

Dreamer78692

[Gysbert_Wassenaar]

Try this:

LOAD Date, Name, Value

WHERE Weekday(Date) <5 ;

[Anonymous]

Hi,

I tried that but for some reason Monday is also not getting loaded.

Kind Regards

Dreamer78692

[MayilVahanan]

Hi

LOAD Date, Name, Value

WHERE Wildmatch(Weekday(Date),'mon','tue','wed','thu','fri');

Hope it helps

[Anonymous · Accepted solution]

Hi,

Try:

LOAD

     Date, Name, Value

WHERE

     Weekday(Date)<>'sat.' AND Weekday(Date)<>'sun.'  ;

(check before that your DayNames is 'sat.' for saturday and 'sun.' for sunday)

[jagan]

Hi,

Try like this

LOAD

     DateFieldName,

    *

FROM DataSource

WHERE WeekDay(DateFieldName) <> 'Sat' OR WeekDay(DateFieldName) = 'Sun';

Hope this helps you.

Regards,

Jagan.

[vivientexier]

A clean way to do this is to use NetWorkDaysDate() function.

LOAD

    Date

  , Name

  , Value

WHERE NetWorkDaysDate(Date, Date) = 1

;