topic Re: store into path with variables in QlikView

store into path with variables

spikenaylor1 — Wed, 25 Nov 2020 16:16:04 GMT

here is my code

FOR vCount = 0 to NoOfTables()-1

LET vTableName = TableName($(vCount));

Let vFilelocation = $(vPathQVDExtract) & '000_Title_Extract_' & $(vTableName) & '.qvd';

STORE $(vTableName) INTO $(vFileLocation) (qvd);

Drop Table $(vTableName);

NEXT vCount

Cant get it to work

keeps giving me an error like

Syntax Error.

Unexpected token: '.', expected nothing

Any help please

Re: store into path with variables

sasiparupudi1 — Wed, 14 Mar 2018 16:57:25 GMT

Try variables in quotes

STORE '$(vTableName)' INTO '$(vFileLocation)' (qvd);

Re: store into path with variables

Chanty4u — Wed, 14 Mar 2018 17:02:48 GMT

try this

STORE $(vTableName) into $(vFileLocation).qvd (qvd);

STORE '$(vTableName)' & ' into $(vFileLocation)'.qvd (qvd);

Re: store into path with variables

tamilarasu — Wed, 14 Mar 2018 17:54:27 GMT

Hi Mike,

Set vTableDrop = '';

FOR vCount = 0 to NoOfTables()-1;

LET vTableName = TableName($(vCount));
Let vTableDrop = '$(vTableDrop)' & If('$(vTableDrop)' ='','',', ') & '$(vTableName)';
Let vFileLocation = '$(vPathQVDExtract)' & '000_Title_Extract_' & '$(vTableName)' & '.qvd';

STORE $(vTableName) INTO [$(vFileLocation)] (qvd);

NEXT vCount

Drop Table $(vTableDrop);

Re: store into path with variables

binujose1982 — Wed, 14 Mar 2018 23:00:20 GMT

Hi Mike,

Please give the file name within single quotes. Also remove all concatenation part.

Let vFilelocation = '$(vPathQVDExtract)000_Title_Extract_$(vTableName).qvd';

FOR vCount = 0 to NoOfTables()-1

LET vTableName = TableName($(vCount));

Let vFilelocation = '$(vPathQVDExtract)000_Title_Extract_$(vTableName).qvd';

STORE $(vTableName) INTO $(vFileLocation) (qvd);

Drop Table $(vTableName);

NEXT vCount

Hope this will help you.

Regards,

Binu