Left Join Two Tables Already in Memory

[cristian_av]

Hi

I have two tables already loaded in memory. I want to do a join between this tables, without having to store one table in a qvd.

How should I do it?

I've tryied in many ways, but the resident table gets concatenated with the original one, and I get a "invalid prefix combination" if I try to use NoConcatenate Load

[LotesFrutaGranelConKgDistribuidos]:

Left Join (LotesFrutaGranel)

LOAD * Resident KilosDistribuidos;

Drop Table LotesFrutaGranel;

Thanks!

[bramkn · Accepted solution]

The table name is not needed here  and why drop the table you are joining to?

[LotesFrutaGranelConKgDistribuidos]:

Left Join (LotesFrutaGranel)

LOAD * Resident KilosDistribuidos;

Drop Table LotesFrutaGranel;

[ziadm]

You should consider using Join Keep

Understanding Join, Keep and Concatenate

[cristian_av]

You're right

It worked:

Left Join (LotesFrutaGranel)

LOAD * Resident KilosDistribuidos;

Drop Table KilosDistribuidos;