i Need your help. I have two fields mont and year. How I get this two fields in one field with load script?
MakeDate(YearField, MonthField) as Date // This will work if month is numerical
Date(Date#(YearField&MonthField&'1', 'YYYYMMMD')) as Date // If month is like - jan. feb...
Month &'-'& Year as New_Month_Year
Month&'-'&Year as MonthYear
Try this in your script :
MonthField&'-'&YearField as MonthYear
Result will be something like this:
Its based on your requirement.
MakeDate(YearField, MonthField, 01) as Date Gives FirstDayofMonth respective year.
YearField&'-'&MonthField as YearMonth Gives ex: 2014-08 or 2014-Aug
MonthField&'-'&YearField as MonthYear Gives ex: 08-2014 or Aug-2014
Hope it helps
Retrieving data ...