Fletching columns from 2 tables?

[priyarane]

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

[#2]

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

[priyarane]

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

[anbu1984]

Qvd1:

Column1,Column2;

Left Join(Qvd1)

Qvd2:

Column3 As Column1,Column4, 1 As Dummy;

Qvd3:

if(IsNull(Dummy),'y','n') as Test_Flag;