Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
You can use the exact function in qlikview. "1_"&Field1 does the same.
Kiran
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
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
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.