How to combine 2 variables into 1?

[Anonymous]

For example,

var_1: 1,4,7

var_2: 2,4,8

=>

var: 1,2,4,7,8

How to achieve it by macro?

[disqr_rm]

Does it has to be macro? YOu can also do it in QV script, which would be my preference:

LET v1 = '1,2,3';
LET v2 = '2,4,5,6';
t1:
LOAD trim(subfield('$(v1)' & ',' & '$(v2)', ',')) as t1
AutoGenerate 1;
t2:
LOAD Concat(DISTINCT t1, ',') as t2
Resident t1
Group by 1;
LET v3 = peek('t2');
DROP Tables t1, t2;

[Anonymous]

Hi Rakesh, I prefer it can be achieve in Macro, because it needn't reload again.