This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration related to QlikView App Development.
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
Left Join (LotesFrutaGranel)
LOAD * Resident KilosDistribuidos;
Drop Table LotesFrutaGranel;
The table name is not needed here and why drop the table you are joining to?
View solution in original post
You should consider using Join Keep
Understanding Join, Keep and Concatenate
Drop Table KilosDistribuidos;