Unexpected token

[LuisM]

I have this problem, someone can help me, how to fix it?

[vinieme12]

You are missing a semicolon  (;)  here after ]

5,Palm De Mallorca,Espana

];

[LuisM]

Hi,

l tried with that   ]; and the problem was fixed but now when l load the data it doesnt do the join and doesnt create my new table "Sitio_Oficina" that l want, why?

[vinieme12]

Please post the script here, I'm not able to view the image

[vinieme12]

You are doing a Left Join(Empleados) Which will add data from Sitio_officina table to Empleados table

After the Left Join ; the columns OficinaCiudad and OficinaPais will be added to Empleados table

Refer this article to learn about Joins/ Keep/Concatenate

https://community.qlik.com/t5/QlikView-App-Dev/Understanding-Join-Keep-and-Concatenate/td-p/328379