topic scripting help in QlikView

scripting help

Anonymous — Thu, 29 Aug 2013 17:04:01 GMT

tab1

--------

id name

---------

1 a

2 b

3 c

tab2

--------

id name

---------

1 a

4 c

5 f

I want to find out those list of records

only present in tab1 and tab2

I want to implement it in the script level

Re: scripting help

Miguel_Angel_Baeyens — Thu, 29 Aug 2013 17:19:55 GMT

Hi,

Using the Exists() clause would do, among some other ways:

tab1:  
 LOAD * INLINE [  
 id, name  
 1, a  
 2, b  
 3, c  
 ];   
   
 tab2:  
 LOAD * INLINE [  
 id2, name2  
 1, a  
 4, c  
 5, f  
 ];  
   
 
 InBothTables: 
 LOAD *,
 1 AS Dummy  
 RESIDENT tab1  
 WHERE Exists(id2, id);  
 CONCATENATE LOAD id2 as id,
 name2 as name,
 1 AS Dummy  
 RESIDENT tab2  
WHERE Exists(id, id2);  
  
DROP TABLES tab1, tab2;
DROP FIELD Dummy

Hope that helps.

Miguel

Re: scripting help

Thu, 29 Aug 2013 17:24:36 GMT

You can do Inner Join between the tables.

Both:

LOAD ID, NAME AS T1_NAME FROM TAB1;

INNER JOIN

LOAD ID, Name as T2_NAME FROM TAB2;

These two tables Join in ID key.

Re: scripting help

CELAMBARASAN — Thu, 29 Aug 2013 17:59:20 GMT

May be you can try with inner keep.

tab1:

Load

id,

name

FROM ...

tab2:

NoConcatenate

Inner Keep

Load

id,

name

FROM ...

Re: scripting help

Anonymous — Fri, 30 Aug 2013 03:11:18 GMT

may be my expression was wrong.

I took help from your query and modified this.It is working fine.

Thanks to all for their contribution.

InBothTables:

LOAD *,

1 AS Dummy

RESIDENT tab1

WHERE not Exists(id2, id);

CONCATENATE

LOAD id2 as id,

name2 as name,

1 AS Dummy

RESIDENT tab2

WHERE not Exists(id, id2);

DROP TABLES tab1, tab2;

DROP FIELD Dummy ;