Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Error: Garbage after statement.

Dears

Could you help me?

I'm running the script but the qlikview shows the message "Garbage after statement" as per snapshot below:

I don't understand which problem that is happening

I'm sending below the snapshot of the script:

Thanks in advance

1 Solution

Accepted Solutions
MayilVahanan

HI

Try like this

LOAD * INLINE [

ID, "Departure City (and Country)", latitude, longitude, Valor

1, 'Itajaí/Brazil', '-26,908258', '-48,662602', 10

2, 'Fortaleza/Brazil', '-3,718394', '-38,543395', 10

3, 'Buenos Aires/ Argentina', '-34,603723', '-58,381593', 10

4, 'Montevideo/Uruguai', '-34,883611', '-56,181944', 10

5, 'Navegantes/Brazil', '-26,899395', '-48,655280', 10

6, 'Porto Alegre/Brasil', '-30,027704', '-51,228735', 10

7, 'Recife/Brazil', '-8,054277', '-34,881256', 10

8, 'Rio de Janeiro/ Brazil', '-22,903539', '-43,209587', 10

9, 'Rio Grande/Brazil', '-32,031941', '-52,099607', 10

10, 'Santos/Brazil', '-23,961836', '-46,332247', 10

11, 'São Paulo/ Brazil', '-23,548943', '-46,638818', 10

];

Hope it helps

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.

View solution in original post

4 Replies
jagan
Partner - Champion III
Partner - Champion III

Hi,

Can you attach the script you are using?

Regards,

Jagan.

Not applicable
Author

Dear, firstly, many thanks for your help

Please, note below the script:

LOAD * INLINE [

ID, [Departure City (and Country)], latitude, longitude, Valor

1, 'Itajaí/Brazil', '-26,908258', '-48,662602', 10

2, 'Fortaleza/Brazil', '-3,718394', '-38,543395', 10

3, 'Buenos Aires/ Argentina', '-34,603723', '-58,381593', 10

4, 'Montevideo/Uruguai', '-34,883611', '-56,181944', 10

5, 'Navegantes/Brazil', '-26,899395', '-48,655280', 10

6, 'Porto Alegre/Brasil', '-30,027704', '-51,228735', 10

7, 'Recife/Brazil', '-8,054277', '-34,881256', 10

8, 'Rio de Janeiro/ Brazil', '-22,903539', '-43,209587', 10

9, 'Rio Grande/Brazil', '-32,031941', '-52,099607', 10

10, 'Santos/Brazil', '-23,961836', '-46,332247', 10

11, 'São Paulo/ Brazil', '-23,548943', '-46,638818', 10

];

LOAD * INLINE [

ID, [Arrival City (and Country)], latitude, longitude, Valor

1, 'Itajaí/Brazil', '-26,908258', '-48,662602', 10

2, 'Fortaleza/Brazil', '-3,718394', '-38,543395', 10

3, 'Buenos Aires/ Argentina', '-34,603723', '-58,381593', 10

4, 'Montevideo/Uruguai', '-34,883611', '-56,181944', 10

5, 'Navegantes/Brazil', '-26,899395', '-48,655280', 10

6, 'Porto Alegre/Brasil', '-30,027704', '-51,228735', 10

7, 'Recife/Brazil', '-8,054277', '-34,881256', 10

8, 'Rio de Janeiro/ Brazil', '-22,903539', '-43,209587', 10

9, 'Rio Grande/Brazil', '-32,031941', '-52,099607', 10

10, 'Santos/Brazil', '-23,961836', '-46,332247', 10

11, 'São Paulo/ Brazil', '-23,548943', '-46,638818', 10

12, 'Assunção/Paraguai', '-25,282197', '-57,635100', 10

13, 'Durban/South Africa', '-29,857876', '31,027581', 10

14, 'Imbituba/Brazil', '-28,240543', '-48,670300', 10

15, 'Paranagua/Brazil', '-25,520469', '-48,509486', 10

16, 'Santiago/ Chile', '-33,469120', '-70,641997', 10

17, 'São Francisco do Sul/Brazil', '-26,242177', '-48,635647', 10

];

MayilVahanan

HI

Try like this

LOAD * INLINE [

ID, "Departure City (and Country)", latitude, longitude, Valor

1, 'Itajaí/Brazil', '-26,908258', '-48,662602', 10

2, 'Fortaleza/Brazil', '-3,718394', '-38,543395', 10

3, 'Buenos Aires/ Argentina', '-34,603723', '-58,381593', 10

4, 'Montevideo/Uruguai', '-34,883611', '-56,181944', 10

5, 'Navegantes/Brazil', '-26,899395', '-48,655280', 10

6, 'Porto Alegre/Brasil', '-30,027704', '-51,228735', 10

7, 'Recife/Brazil', '-8,054277', '-34,881256', 10

8, 'Rio de Janeiro/ Brazil', '-22,903539', '-43,209587', 10

9, 'Rio Grande/Brazil', '-32,031941', '-52,099607', 10

10, 'Santos/Brazil', '-23,961836', '-46,332247', 10

11, 'São Paulo/ Brazil', '-23,548943', '-46,638818', 10

];

Hope it helps

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
Not applicable
Author

Perfect, It's OK now

Many thanks for your help!