Discussion Board for collaboration related to QlikView App Development.
I have two tables that I want to concatenate. When I Use the order (A) next (B), then the last table (B) clears the "Llave" table instead of concatenating with (A).
If I invert the tables, (A) clears the LLave table instead of concatenating.
I don't know what could be happening.
Load DISTINCT LlaveMatriz, LlaveMatriz as LlaveUnion Resident Matriz Where espe_nombre<>'S/E';
Join(Llaves) Load DISTINCT
LlaveVolumen as LlaveUnion
DROP FIELD LlaveUnion;
LOAD LlaveVolumen as LlaveMatriz,
LlaveVolumen as LlaveVolumenBusqueda,
coge_nombre as coge_nombre1,code_nombre as code_nombre1
FROM [CombVolumen.qvd] (qvd);
What happens if you comment out the Join at the end ?
They concatenate! Don't know why..
What were you trying to achieve with the join ?
I'm trying to create all the possible combinations for a table, as I need an intermediate table to connect with the table that has data.