Load script make of two fields one

[#1]

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

[tresesco · Accepted solution]

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...

[PrashantSangle]

Hi,

Try this,

Month &'-'& Year as New_Month_Year

Regards,

[ashfaq_haseeb]

Hi,

try below

Load

Day,

Month,

Year,

Date,

Month&'-'&Year as MonthYear

from test.qvd;

Regards

ASHFAQ

[hannan_t]

Try this in your script :

MonthField&'-'&YearField as MonthYear

Result will be something like this:

Aug-2014

[MayilVahanan]

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