topic Re: Can We Join Resident Table with other Table ? in QlikView

Can We Join Resident Table with other Table ?

Thu, 22 May 2014 03:53:31 GMT

Hi All,

I am new to qlikview.

Can we join Resident Table with any other Table ?

Example :

Test :

Load

Resident Test11;

Test2:

LEFT JOIN (Test)

Load *

from QVD;

I am trying to follow above,

but, it does not allow me and i am getting error.

can someone explain ?

any help would be appreciated.

Re: Can We Join Resident Table with other Table ?

simospa — Thu, 22 May 2014 04:16:12 GMT

LEFT JOIN instuction might be out of the declaration of Test2 entity, try this:

Test :

Load

Resident Test11;

LEFT JOIN

Test2:

Load *

from QVD;

Test2:

Load *

from QVD;

LEFT JOIN

Test :

Load

Resident Test11;

Re: Can We Join Resident Table with other Table ?

Anonymous — Thu, 22 May 2014 04:26:04 GMT

Hi Hailey,

Test : Load * Resident Test11;

When your loading Load * resident table to another table Test it will concatenate both table and store result in Test11 as it create first. and Test won't exist any more.

1st if want both table you should use NoConcatenate before Test : Load * Resident Test11;

this will solve your problem.

But it will create synthetic table and key which generally not preferred good design.If you brief more what you actually want to I can help you better way.

Thanks & Regards

Kiran Kokade

Re: Can We Join Resident Table with other Table ?

Thu, 22 May 2014 05:00:48 GMT

Hi,

try like this.

NoConcatenate

test:

load * Resident test11;

left join load * from test2.qvd(qvd);

Thanks,

-krishna kumari

Re: Can We Join Resident Table with other Table ?

Thu, 22 May 2014 05:11:36 GMT

Hi,

Inorder to avoid synthetic key and if you don't need resident table test11,

we can drop resident table after joining the tables. I hope this might help you.

Please correct me if I am wrong, as I am also new to qlikview

Thanks,

Krishna kumari

Re: Can We Join Resident Table with other Table ?

Anonymous — Thu, 22 May 2014 05:31:20 GMT

Hi krishna,

In this case better don't use

test:

load * Resident test11;

Because we can directly use test11 instead of test.Creating identical table doesn't make sense if you are not performing any additional transformation.

Thanks & Regards,

Kiran Kokade

Re: Can We Join Resident Table with other Table ?

Thu, 22 May 2014 05:49:00 GMT

okay Kiran, I understood.

Thank you so much for your reply

-Krishnakumari