how to concat a string with a field

[Anonymous]

I need to concatenate a string 'P' with another field Priority. Priority has values 1,2,3,4,5

Essentially the values in the revised_priority need to be P1,P2,P3,P4,P5 instead of 1,2,3,4,5

i tried doing the following but it shows invalid expression so i am not sure what is wrong with my expression

load
*,
concat('P'&Priority) as Revised_Priority

Resident Problems group by [Problem Number];

can anybody please help me with the syntax?

[sushil353 · Accepted solution]

hi,

the problem here will be with Load *,

try this:

load
[Problem Number],
concat('P'&Priority) as Revised_Priority
Resident Problems group by [Problem Number];

The above script should work..

so the thumb rule is if you are using group by then include all the fields in group by which are in your select/load statement.

HTH

Sushil

[vinieme12]

just this much should work

load
*,
'P'&Priority as Revised_Priority
Resident Problems;

[Anonymous]

Thanks..both the solutions worked fine