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.

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

Re: Error: Garbage after statement.

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

4 Replies
MVP & Luminary
MVP & Luminary

Re: Error: Garbage after statement.

Hi,

Can you attach the script you are using?

Regards,

Jagan.

Not applicable

Re: Error: Garbage after statement.

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

];

Re: Error: Garbage after statement.

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

Not applicable

Re: Error: Garbage after statement.

Perfect, It's OK now

Many thanks for your help!