data reduce?

[Anonymous]

Hi

i have

city:

bang

che

hyd

kerala   and

area:

tinfactory

annasalai

hitechcity

ooty

sub area:

factory1

factory2

factory3

factory4

have data from last yer to till today  

my req i want write a condition to show data for 'ooty'   only nov 2014 onwards before nov 2014 want exclude ?

how ?

[PrashantSangle]

Hi,

Acheive this in two steps;

step1:

Load all data excluding Area='ooty'

Step2:

Load Data only for Area='ooty' and Month Year>='Nov 2014'

and concatenate with table created in step1;

Regards

[Ralf-Narfeldt]

I assume you have a date field in the data as well, let's call it dateField.

So you could add a condition at the end of your LOAD statement like:

WHERE area = 'ooty' AND dateField > Date('2014/11/30')

Of course you have to change dateField to your field name and adjust the date format to the format you use

[Anonymous]

but i want exclude this date for only  'ooty'  if i go this exclusion  for other areas also dates will get excluded

[Ralf-Narfeldt]

Ah, didn't understand you wanted the exclusion for ooty only. Just a small change:

WHERE NOT (area = 'ooty' AND dateField < Date('2014/12/01'))

[Anonymous]

Go with max dreamer's suggestion.

That is the correct one

Let me know if you face any issues