Load script hangs while left join

[dhanavindhan]

Dear Experts,

I have multiple qvd's contains some columns which are already used for different report. Now, I am creating a new dashboard screen I want only some columns from that qvd's. While I do left join in my load script my machine get hang. FYR I attached my load script image. Please help me to fix this issue in a optimized way becoz I have some more qvd to join with this and make a single table.

Regards,

Dhana R

[Anonymous]

try it with

unqualify *;

first

[dhanavindhan]

Hi,

Tanx for ur reply

I don't understand ur answer. Pls enlighten me.

Regards,

Dhana R

[Anonymous]

Hi I thought perhaps you're using qualify and thatswhy the names of your keys aren't identical.

Could you please post a screenshot of the two tables (CTRL + T)  without using join?