topic Re: Vertical Bar || merging coluns in Select database in App Development

Vertical Bar || merging coluns in Select database

rbr199 — Thu, 15 Dec 2022 15:35:56 GMT

Hi all.

I just got a database as a "heritage" from my former peer and I faced a problem while merging two columns into a new one as a Case. I tried to find several hints and guides, but the vertical bars command " || " worked well and I could find nothing even in Qlik guides explaining how it works.

The example below is that I'm using:

SELECT

CTB.BATCH,
CTB.SEQUENCE,
CTB.BATCH || '/' || CTB.SEQUENCE as BATCH _SEQUENCE,

FROM...

Does anyone knows why this works in Qlik? My former peer already left the company without this explanation for me and I can't reach him.

Re: Vertical Bar || merging coluns in Select database

Or — Thu, 15 Dec 2022 15:55:19 GMT

This isn't Qlik script. This is an SQL query that is passed on to the database as, so the concatenation is being handled on that side of things.

Re: Vertical Bar || merging coluns in Select database

rbr199 — Thu, 15 Dec 2022 15:59:44 GMT

I agree with you, but the SQL concat I usually see uses a command +, not the ||. This still is a mistery for me.

Re: Vertical Bar || merging coluns in Select database

Vishal_Gupta — Fri, 16 Dec 2022 06:29:29 GMT

Hi @rbr199,

SQL Concatenate Operator uses || not + if I am not wrong.

Please check SQL Documentations for more details on this.

For reference:

SQL | Concatenation Operator - GeeksforGeeks

Re: Vertical Bar || merging coluns in Select database

rbr199 — Fri, 16 Dec 2022 13:44:42 GMT

Thank you.

Re: Vertical Bar || merging coluns in Select database

vinieme12 — Mon, 19 Dec 2022 08:25:00 GMT

different database support different concatenation operators some support '+' some support '||'