topic QVD JOIN TABLE in QlikView

QVD JOIN TABLE

Wed, 22 Jun 2011 16:45:36 GMT

Hello,

Quick question. Can QVD file be join with a table with a join clause?

Your help is appreciated!

Wed, 22 Jun 2011 16:51:23 GMT

Trying to do something like this, but it is feasible?

FROM (qvd) a join (select distinct pos from dbo.Mapping with(nolock)) b

on a.pos=b.pos

kaushiknsolanki — Wed, 22 Jun 2011 17:27:11 GMT

Hi,

Its very simple. Try following.

Select Distinct pos

from dbo.mapping;

join

Load abc,pos

from xyz.qvd (qvd);

Make sure that joining field have same name in both the table.

Regards,

Kaushik Solanki