Fetching only Wednesday

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Fetching only Wednesday

Anil_Babu_Samineni — Tue, 09 Jan 2018 06:26:31 GMT

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