Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
cristian_av
Creator III
Creator III

Left Join Two Tables Already in Memory

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!

1 Solution

Accepted Solutions
bramkn
Partner
Partner

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;

View solution in original post

3 Replies
bramkn
Partner
Partner

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;

View solution in original post

ziadm
Specialist
Specialist

You should consider using Join Keep

Understanding Join, Keep and Concatenate

cristian_av
Creator III
Creator III
Author

You're right

It worked:

Left Join (LotesFrutaGranel)

LOAD * Resident KilosDistribuidos;

Drop Table KilosDistribuidos;