Cannot concatenate two Resident Tables

[cristian_av]

Hi

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;

[Anonymous]

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

[cristian_av]

They concatenate! Don't know why..

[Anonymous]

What were you trying to achieve with the join ?

[cristian_av]

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.