Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Highlighted
Hollis
Not applicable

'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
rwunderlich
Not applicable

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
Not applicable

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
Not applicable

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.
rwunderlich
Not applicable

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
Not applicable

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

Thanks a lot.