Is it possible to use variable in Store command

[#1]

Is it possible to use variable in Store command  ? Like  STORE $(srctab) into $(tgttab);

??

[swuehl]

Yes.

[#3 · Accepted solution]

Hi,

Just in case you or someone else needed an example:

[Table 1]:

LOAD * Inline [
f1, f2
a,1
b,2
c,3
];

[Table 2]:
LOAD * Inline [
f3,f4
d,4
e,5
f,6
g,7
h,8

i,9
];



for i=0 to NoOfTables()-1
     let vtbl = TableName($(i));
     let vrows = NoOfRows('$(vtbl)');

     if $(vrows)>5 then
          set vstore = 'C:\Users\Test\Desktop\QVW\Over5\';
     else
          set vstore = 'C:\Users\Test\Desktop\QVW\LessThan5\';
     ENDIF

     STORE '$(vtbl)' into $(vstore)$(vtbl).qvd;
next

[#4]

Thanks a lot