topic Re: Is it possible to use variable in Store command in QlikView

Is it possible to use variable in Store command

Fri, 26 Jul 2013 09:27:43 GMT

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

Re: Is it possible to use variable in Store command

swuehl — Fri, 26 Jul 2013 09:38:29 GMT

Yes.

Re: Is it possible to use variable in Store command

Fri, 26 Jul 2013 10:00:16 GMT

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

Re: Is it possible to use variable in Store command

Fri, 26 Jul 2013 10:11:48 GMT

Thanks a lot