Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Experts,
Is it possible to fletch data from two tables/qvds?
Like:
Qvd1:
Column1,Column2
From Qvd1;
Qvd2:
Column3,Column4
From Qvd2;
Now I want to create one more qvd/table, its combination of 2 qvds/2tables.
Like
Qvd3:
Qvd1.Column1,Qvd2.Column4
From Qvd1,Qvd2;
How to make it possible?
Please help me
we can't compare two fields in RDBMS way in Qlik as it works on AQL. Personally i solved situations like this by bringing the both fields in one table (through join) then did comparison.
Please educate me if any better thoughts
Hi Guruprem,
I could't solve it in QV and so I took from DB developer's help. He gave CASE statements like below;
CASE WHEN (j.FTP_ENTITY_CODE IN (select FTP_ENTITY_CODE_PARENT from RWA..FTP_LE_MAPPING where LEGAL_ENTITY = 'HBUS' ) OR j.FTP_ENTITY_CODE IN (select FTP_ENTITY_CODE_CHILD from RWA..FTP_LE_MAPPING
where LEGAL_ENTITY = 'HBUS')) and (isnull(j.FTP_AFFILIATE,'') NOT IN (select FTP_ENTITY_CODE_PARENT from RWA..FTP_LE_MAPPING where LEGAL_ENTITY = 'HBUS' ) OR isnull(j.FTP_AFFILIATE,'') NOT IN (select
FTP_ENTITY_CODE_CHILD from RWA..FTP_LE_MAPPING where LEGAL_ENTITY = 'HBUS'))
then 'Y'
else 'N'
end as Trad_IS_HBUS_FLAG
Qvd1:
Column1,Column2;
Left Join(Qvd1)
Qvd2:
Column3 As Column1,Column4, 1 As Dummy;
Qvd3:
if(IsNull(Dummy),'y','n') as Test_Flag;