Fetching only Wednesday

[Anonymous]

Hi All,

     I need to fetch records only from some particular days, for ex I need to fetch only on max(Wednesday). so if I refresh I need to fetch

only 01/03 . As it is involving in data fetch layer I need to put this condition.

My data source table from Hive. Kindly let me know.

-Jai

[Anil_Babu_Samineni]

Not sure entirely sure where and what you want?

Set DayNames = 'Monday;Tuesday;Wednesday;..'

Approach-I

Load * Where DateField = Match(WeekDay(DateField), 'Wednesday'); // This string comes from Variable which in blue

Hive Table Loaded;

Approach-II

Sample:

Hive Table Loaded;

Final:

NoConcatenate

Load * Resident Sample;

Drop Table Sample;

Right Join (Final)

Load Max(DateField) as DateField

Resident Final Where DateField = Match(WeekDay(DateField),'Wednesday'); // This string comes from Variable which in blue