topic add character to value in QlikView

add character to value

Wed, 26 Oct 2011 12:57:48 GMT

hello community, is there a function to add characters to a value during load ?

F.e. in Excel, there is a function [="1_"&C58] which would add 1_ to the data from C58.

So "1234" would end up as "1_1234" OR "cake" would become "1_cake"

the same is possible on other positions of the value

F.E. ="A_"&C58&"_B" would become "A_1234_B"

Is there something similar in qlikview ?

Thanks

alex

add character to value

Wed, 26 Oct 2011 13:02:05 GMT

You can use the exact function in qlikview. "1_"&Field1 does the same.

Kiran

add character to value

its_anandrjs — Wed, 26 Oct 2011 13:02:23 GMT

Hi,

Yes it is possible by adding & same as excel to the field then you get a concat new field

like Example

Temp:

load * inline

[

COLA

];

Data:

Load

'A_'&COLA AS new

Resident Temp;

Rgds

Anand

Re: add character to value

its_anandrjs — Wed, 26 Oct 2011 13:05:14 GMT

Hi,

See the attached sample file

Example like

Temp:

load * inline

[

COLA

];

Data:

Load

'A_'&COLA&'_B' AS New1,

'1_'&COLA AS New2

Resident Temp;

Rgds

Anand

add character to value

jduenyas — Wed, 26 Oct 2011 16:49:45 GMT

Be careful. If you use a straight SQL statement then replace the ampersand, as suggested by others, with a plus sign.

"1_" & Filed1 will become "1_" + Field1.

Also make sure that the data types are compatible. You cannot append string to numeric data types.