I would like to :
We have a createdon date.Now,
create a string field i.e. fiscalyear in the load statement
create start and end date based on hard code dates.
use conditional statement , if createddate lies between the start and end date then assign the fiscialyear field to some string value..
date(2011-04-01, "YYYY-MM-DD") As datestarst;
date(2012-03-31, "YYYY-MM-DD") As dateends;
Fiscalyear As fy_year
LOAD *inline [
LOAD CreatedOn as CampaignCreatedOn,
If (CampaignCreatedOn) >= (datestarst)
If(CampaignCreatedOn) <= (datestarst)
fy_year = "FY11"
wondered if its possible or ??