Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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;
hi
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;
hi i am do this but not give the table column name after reload the edit script