Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello together,
i Need your help. I have two fields mont and year. How I get this two fields in one field with load script?
Thanks
Jörn
Try like:
Load
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...
Try like:
Load
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...
Hi,
Try this,
Month &'-'& Year as New_Month_Year
Regards,
Hi,
try below
Load
Day,
Month,
Year,
Date,
Month&'-'&Year as MonthYear
from test.qvd;
Regards
ASHFAQ
Try this in your script :
MonthField&'-'&YearField as MonthYear
Result will be something like this:
Aug-2014
Hi
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