topic Re: Concatenate string to FIELD in SQL in QlikView

Concatenate string to FIELD in SQL

Anonymous — Tue, 18 Mar 2014 14:14:36 GMT

Hi,

i have fileds YEAR and MONTH in a table and i want to create a string like "YEAR-MONTH" (2012-05 )

How can i do?

SQL SELECT

YEAR as `dat.year`,

MONTH as `dat.month`

[B.YEAR] &'-'& [B.MONTH] as `dat.timing` ????

date([B.YEAR]+[B.MONTH],'YYYYMM') as `dat.timing`, ?????

Thanks

Re: Concatenate string to FIELD in SQL

hic — Tue, 18 Mar 2014 14:37:39 GMT

The best way is to use a Preceding Load:

Load

Year,

Month,

Date(MakeDate(Year, Month),'YYYY-MM') as YearMonth;

SQL SELECT

YEAR as Year,

MONTH as Month

FROM ...

HIC

Re: Concatenate string to FIELD in SQL

Gysbert_Wassenaar — Tue, 18 Mar 2014 14:37:39 GMT

That depends on the sql dialect of the source database. In Oracle you use two pipe symbols 'A' || 'B'. In SQL server you use the + sign iirc, 'A' + 'B'. If you're not sure, ask your local friendly database administrator.

Or, like Henric says, use a preceding load. Often so much simpler and more powerful.