How to add a calculated field in load script or table box?

[#1]

Hi there,

I am a beginner.

i want to adds a calculated field 'FY' base on original field 'month' in load script or table box.

the logic is ' if month is November or December, then FY is 'next year', else 'current year.'

thank you in advance!

[anbu1984]

In Script,

Load Month, If(Wildmatch(Month,'November','December'),Year(Today())+1,Year(Today())) As FY

From Table;

If you have year field, then replace Year() by year field in above script

[sagarkharpude]

if(month='November' or month='December',$(vnextyear),$(currentyear)) as FY

Create the variable as vnextyear=year(today()+1)

currentyear=year(today())

[jagan]

Hi,

Try like this in script

LOAD

*,

If(MixMatch(month, 'November', 'December'), Year(DateFieldName) + 1, Year(DateFieldName))  AS  FY

FROM DataSource;

Hope this helps you.

Regards,

Jagan.