Concatenating two different fields

[#1]

Hi,

I need to create a field called Year-Month using the available fields Year and Month,the new field Year-Month must have values being concatenated from the existing column Year and month the values in Year-Month must be like 20009-Jan,20009-Feb,....

Can anyone please help me acheive this.Please find the attached document

[mdmukramali]

Dear,

Create a filed in the script,

                                       Year&'-'&My_Month as Year_Month

Thanks,

mukram.

[#3]

Thanks

Thanks & Regards,

Anushree Shetty

[amars]

Please check the attached file.

Thanks...

[qlikpahadi07]

LOAD Year,

     My_Month,

     Year &'-'& My_Month as YearMonth

FROM

(ooxml, embedded labels, table is Sheet1);