add character to value

[#1]

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

[#2]

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

Kiran

[its_anandrjs · Accepted solution]

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

12

13

14

15

16

];

Data:

Load

'A_'&COLA AS new

Resident Temp;

Rgds

Anand

[its_anandrjs]

Hi,

See the attached sample file

Example like

Temp:

load * inline

[

COLA

12

13

14

15

16

];

Data:

Load

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

'1_'&COLA AS New2

Resident Temp;

Rgds

Anand

[jduenyas]

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.