Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Highlighted
Hollis
New Contributor II

'Unexpected token' error - Upgrade from QV 11 to QV12

Hi Guys,

I used the subroutine to stored files in csv-format, the related scripts is as below:

STORE * from [$(aTable2Store)] into $(vQVD_TRA)\$(aTable2Store).csv (ansi, txt, delimiter is ';');

It works well in QV11, but when run in QV12, it shows the error message.

Error: Unexpected token: 'ansi', expected one of: 'qvd', 'txt', 'qvx', 'delimiter'.

Anyone can help?

Thank you very much.

Labels (1)
1 Solution

Accepted Solutions
MVP & Luminary
MVP & Luminary

Re: 'Unexpected token' error - Upgrade from QV 11 to QV12

QV12 is more strict on syntax. "ansi" never was a valid keyword for STORE, but QV11 tolerated (and ignored it). QV12 does not. 

-Rob

4 Replies
joseph_morales
New Contributor III

Re: 'Unexpected token' error - Upgrade from QV 11 to QV12

Hi @Hollis 

You must delete the ANSI

STORE * from [$(aTable2Store)] into $(vQVD_TRA)\$(aTable2Store).csv (txt, delimiter is ';');

Regards

 

 

Hollis
New Contributor II

Re: 'Unexpected token' error - Upgrade from QV 11 to QV12

Hi Joseph_Morales,
May I know the reason for this? Since it works well in QV11.
MVP & Luminary
MVP & Luminary

Re: 'Unexpected token' error - Upgrade from QV 11 to QV12

QV12 is more strict on syntax. "ansi" never was a valid keyword for STORE, but QV11 tolerated (and ignored it). QV12 does not. 

-Rob

Hollis
New Contributor II

Re: 'Unexpected token' error - Upgrade from QV 11 to QV12

Thanks a lot.