Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
Hi,
Can you attach the script you are using?
Regards,
Jagan.
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
];
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
Perfect, It's OK now
Many thanks for your help!