Solved

[microwin88x]

Solved

[Gabriel]

Hi,

You can use Concat function in your variable. The content of your variable is

Concat(Chr(39) & Amount & Chr(39),',') //Chr(39) is Single Quote

[rubenmarin · Accepted solution]

Hi, you can try with this script:

Table:
LOAD * Inline [
FieldA
50
55
60
AB
CD
EF
];

Temp:
NoConcatenate LOAD Chr(39) & Concat(FieldA, Chr(39)& ',' & Chr(39)) & Chr(39) as FieldB
Resident Table; //We create the value to the variable in a field

LET vTable= FieldValue('FieldB', 1); //Assign the field value
DROP table Temp;

[Kushal_Chawda]

Data:
LOAD *  Inline [
Field
50
55
60
AB
CD
EF
];

Field:
NoConcatenate
LOAD Concat(DISTINCT Chr(39)& Field & Chr(39),',' ) as NewField
Resident Data;

let vTable = Peek('NewField',0,'Field');

[trdandamudi]

You can create the variable in Variable overview.See attached screen shot: