Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Solved
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;
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
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;
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');
You can create the variable in Variable overview.See attached screen shot: