topic Re: Join in QV script in QlikView

Join in QV script

Tue, 27 Aug 2013 12:52:55 GMT

Hi,

could anyone translate following sql into qv:

left join table2fieldX on table2fieldA=table1fieldB and table2fieldC = string?

I want to load from QVD's and make the join there.

Kr,

Daniel

rajeshvaswani77 — Tue, 27 Aug 2013 13:00:29 GMT

mytable:

LOAD

fieldA as Link

from table1;

left join (mytable)

LOAD

fieldB as Link,

fieldC

from table2 where fieldC=string;

thanks,

Rajesh Vaswani

Tue, 27 Aug 2013 13:38:46 GMT

Thanks a bunch! You're a life saver!

rajeshvaswani77 — Tue, 27 Aug 2013 13:46:36 GMT

Hi Daniel,

Could you please mark as correct answer or helpful answer.

regards,

Rajesh Vaswani

Tue, 27 Aug 2013 14:13:02 GMT

Sorry,

here you go.