topic Re: Join Condition in QlikView

Join Condition

Thu, 06 Feb 2014 04:49:56 GMT

I have a Scenario , where i need to Write a Query and in that query i give the joins between the table the problem is when i write the query in Edit script. and reload the query after executing reload script . they dnt give me table column name .if anyone know help me.

is there is any way i can write this Query in Qlik View.

for example:

LOAD p_department,

p_personid,

pr_description,

rl_rfqnum,

prl_pnum,

po_pnum,

prl.polinenum,

po_status;

SQL

Select p_department,

p_personid,

pr_description,

rl_rfqnum,

prl_pnum,

po_pnum,

prl.polinenum,

po_status

from person p

left join pr pr

on pr_requestedby = p_personid

left join prline prl

on pr_pnum = prl_pnum

left join rf r

on prl_rfqnum = r_rfqnum

left join rfline rl

on r_rfqnum = rl_rfqnum

left join po po

on prl_pnum = po_pnum

left join poline pol

on po_pnum = pol_pnum;

Re: Join Condition

Thu, 06 Feb 2014 04:53:46 GMT

simply write this

Test_Tablename:

LOAD p_department,

p_personid,

pr_description,

rl_rfqnum,

prl_pnum,

po_pnum,

prl.polinenum,

po_status;

SQL

Select p_department,

p_personid,

pr_description,

rl_rfqnum,

prl_pnum,

po_pnum,

prl.polinenum,

po_status

from person p

left join pr pr

on pr_requestedby = p_personid

left join prline prl

on pr_pnum = prl_pnum

left join rf r

on prl_rfqnum = r_rfqnum

left join rfline rl

on r_rfqnum = rl_rfqnum

left join po po

on prl_pnum = po_pnum

left join poline pol

on po_pnum = pol_pnum;

Re: Join Condition

Thu, 06 Feb 2014 04:59:17 GMT

hi i am do this but not give the table column name after reload the edit script

Re: Join Condition

Thu, 06 Feb 2014 06:16:38 GMT

below link may help u ...

http://community.qlik.com/groups/qvscriptor-from-schema-to-script/blog/2011/11/11/understanding-join-keep-and-concatenate