topic Re: how can I concatenate symbols with fields in select? in QlikView

how can I concatenate symbols with fields in select?

Fri, 14 Mar 2014 19:37:44 GMT

how can I concatenate symbols with fields in select?

Like:

SQL SELECT

num_cont & '/' & year_cont as contract,

Re: how can I concatenate symbols with fields in select?

rustyfishbones — Fri, 14 Mar 2014 19:49:36 GMT

You can do this in Qlikview as a List box Expression

Re: how can I concatenate symbols with fields in select?

Nicole-Smith — Fri, 14 Mar 2014 19:52:19 GMT

Something like this should do it (I'm guessing your fields are numbers by the way they're named):

SQL SELECT

cast(num_cont as varchar(50)) + '/' + cast(year_cont as varchar(50)) as contract,

Re: how can I concatenate symbols with fields in select?

Fri, 14 Mar 2014 19:53:05 GMT

Like this:

Load *,

Field1 &'_'& Field2 as Key ;

SQL Select *

From DataBase:

Thanks

Re: how can I concatenate symbols with fields in select?

rustyfishbones — Fri, 14 Mar 2014 19:54:46 GMT

not sure this can be done in Qlikview??

Do you have a sample of how this works Nicole

Thanks

Alan

Re: how can I concatenate symbols with fields in select?

Nicole-Smith — Fri, 14 Mar 2014 19:55:59 GMT

I have a sample but it's not like you can connect to my database...

Re: how can I concatenate symbols with fields in select?

rustyfishbones — Fri, 14 Mar 2014 20:05:43 GMT

Yes indeed,

but can you share the script that shows this

What is the Syntax?

Re: how can I concatenate symbols with fields in select?

Fri, 14 Mar 2014 20:11:09 GMT

thx, this work.

Re: how can I concatenate symbols with fields in select?

Nicole-Smith — Fri, 14 Mar 2014 20:11:16 GMT

SQL SELECT

cast(Field1 as varchar(50)) + '/' + cast(Field2 as varchar(50)) as Test

FROM Table;

Re: how can I concatenate symbols with fields in select?

rustyfishbones — Fri, 14 Mar 2014 20:18:27 GMT

does not work for me,

can you take a snapshot of your script, here is what I have and it does not work for me

Re: how can I concatenate symbols with fields in select?

Nicole-Smith — Fri, 14 Mar 2014 20:22:56 GMT

The two fields I'm using are numbers because I figured that's what the original post was about. Looks like you're using strings...

My code is exactly what I posted plus the DB connect statement.