how can I concatenate symbols with fields in select?

[#1]

how can I concatenate symbols with fields in select?

Like:

SQL SELECT

  num_cont & '/' & year_cont as contract,

[rustyfishbones]

You can do this in Qlikview as a List box Expression

[Nicole-Smith]

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,

[#4 · Accepted solution]

Like this:

Load *,

Field1 &'_'& Field2 as Key ;

SQL Select *

From DataBase:

Thanks

AJ

[rustyfishbones]

not sure this can be done in Qlikview??

Do you have a sample of how this works Nicole

Thanks

Alan

[Nicole-Smith]

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

[rustyfishbones]

Yes indeed,

but can you share the script that shows this

What is the Syntax?

[#8]

thx, this work.

[Nicole-Smith]

SQL SELECT

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

FROM Table;

[rustyfishbones]

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