Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
cristian_av
Creator III
Creator III

Cannot concatenate two Resident Tables

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;

4 Replies
bill_markham

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

cristian_av
Creator III
Creator III
Author

They concatenate! Don't know why..

bill_markham

What were you trying to achieve with the join ?

cristian_av
Creator III
Creator III
Author

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.