Can We Join Resident Table with other Table ?

[#1]

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.

[simospa]

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

Test :

  Load

               *

         Resident Test11;

LEFT JOIN

Test2:

   Load *

         from QVD;

or

Test2:

   Load *

         from QVD;

LEFT JOIN

Test :

   Load

               *

         Resident Test11;

[Anonymous]

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

[#4]

Hi,

try like this.

NoConcatenate

test:

load * Resident test11;

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

Thanks,

-krishna kumari

[#5]

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

[Anonymous]

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

[#7]

okay Kiran, I understood.

Thank you so much for your reply

-Krishnakumari