Hi everyone, In the loading editor I am trying to build a table by concatenating data from a table to a table built by joining two different tables. This is a procedure that I have already used in other places in my code, where it works like a charm. Here, however, raises an error. My code is something like this:
[qlik_table_1]:
LOAD
[field_1],
[field_2];
SELECT `field_1`,
`field_2`
FROM DB.`table_1`
WHERE `field_2` is not null;
JOIN([qlik_table_1])
LOAD
[field_1],
[field_3];
SELECT `field_1`,
sum(`field_3`) as `field_3`
FROM DB.`table_2`
GROUP BY `field_1`;
LOAD
[field_1],
[field_2],
[field_3],
SELECT DB.`table_3`.`field_1`,
`field_2`,
DB.`table_4`.`field_3`
FROM DB.`table_3`
INNER JOIN DB.`table_4` ON DB.`table_3`.`field_2` = DB.`table_4`.`field_2`;
When I try to load the data, however, I get the error "Connector error: ERROR [3D000] [Qlik][MySQL] No database selected" on the following part:
SELECT DB.`table_3`.`field_1`,
`field_2`,
DB.`table_4`.`field_3`
FROM DB.`table_3`
INNER JOIN DB.`table_4` ON DB.`table_3`.`field_2` = DB.`table_4`.`field_2`;
How is this possible, if the database is the same that I have used in all the other SELECT statements in the code? And how can I solve this?
