topic Re: Left Join Two Tables Already in Memory in QlikView

Left Join Two Tables Already in Memory

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

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!

Re: Left Join Two Tables Already in Memory

bramkn — Fri, 23 Mar 2018 14:35:23 GMT

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;

Re: Left Join Two Tables Already in Memory

ziadm — Fri, 23 Mar 2018 14:37:42 GMT

You should consider using Join Keep

Understanding Join, Keep and Concatenate

Re: Left Join Two Tables Already in Memory

cristian_av — Fri, 23 Mar 2018 15:06:01 GMT

You're right

It worked:

Left Join (LotesFrutaGranel)

LOAD * Resident KilosDistribuidos;

Drop Table KilosDistribuidos;