topic Re: Re: Concatenating two different fields in QlikView

Concatenating two different fields

Tue, 01 Oct 2013 09:17:50 GMT

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

Re: Concatenating two different fields

mdmukramali — Tue, 01 Oct 2013 09:23:36 GMT

Dear,

Create a filed in the script,

Year&'-'&My_Month as Year_Month

Thanks,

mukram.

Re: Concatenating two different fields

Tue, 01 Oct 2013 09:30:30 GMT

Thanks

Thanks & Regards,

Anushree Shetty

Re: Re: Concatenating two different fields

amars — Tue, 01 Oct 2013 09:32:36 GMT

Please check the attached file.

Thanks...

Re: Concatenating two different fields

qlikpahadi07 — Tue, 01 Oct 2013 11:28:06 GMT

LOAD Year,

My_Month,

Year &'-'& My_Month as YearMonth

FROM

(ooxml, embedded labels, table is Sheet1);