topic Re: Cannot concatenate two Resident Tables in QlikView

Cannot concatenate two Resident Tables

cristian_av — Wed, 25 Nov 2020 16:16:04 GMT

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.

Any help?

Thanks!!

(A)

Llaves:

Load DISTINCT LlaveMatriz, LlaveMatriz as LlaveUnion Resident Matriz Where espe_nombre<>'S/E';

Join(Llaves) Load DISTINCT

LlaveVolumen,

LlaveVolumen as LlaveUnion

Resident Volumen;

DROP FIELD LlaveUnion;

(B)

Concatenate (Llaves)

LOAD LlaveVolumen as LlaveMatriz,

LlaveVolumen as LlaveVolumenBusqueda,

LlaveSinEspecie,

coge_nombre as coge_nombre1,code_nombre as code_nombre1

FROM [CombVolumen.qvd] (qvd);

Join(Llaves) Load DISTINCT

LlaveVolumen,

LlaveSinEspecie

Resident Volumen;

Re: Cannot concatenate two Resident Tables

Anonymous — Wed, 28 Dec 2016 18:24:16 GMT

What happens if you comment out the Join at the end ?

Re: Cannot concatenate two Resident Tables

cristian_av — Wed, 28 Dec 2016 18:28:48 GMT

They concatenate! Don't know why..

Re: Cannot concatenate two Resident Tables

Anonymous — Wed, 28 Dec 2016 18:37:03 GMT

What were you trying to achieve with the join ?

Re: Cannot concatenate two Resident Tables

cristian_av — Wed, 28 Dec 2016 18:41:47 GMT

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.