Concatenate a string to variable and use it as a field

[saumyashah90]

Suppose i have 1 ,2,3,4,5 values comming out of variable "$(vPrevWeek)" and i want in field as Wk1,Wk2,Wk3,etc

I that means I want to concatenate string 'Wk' with $(VPrevWeek) and output of this iwant as Wk1,Wk2 which i want to use as field.How to do it?

[Sokkorn · Accepted solution]

Hi Saumya,

Not sure you try this yet:

'Wk' & $(vPrevWeek) As [Weeks]

Regards,

Sokkorn

[#3]

table1:

load * inline [

value

1

2

3

4

5

];

load

'wk' & value as  value_new

resident table1;