topic Requirement in QlikView

Requirement

kulasekhar — Thu, 21 May 2015 05:37:14 GMT

Hi All,

Col1 is in Table1

----

12345

2345

3456

4567

5678

Col 2 is in Table2

-------

12345

9876

1234

2345

4567

Result should be :

3456

5678

Unmatched values from Col1 as ResultColumn

Thanks,

Kula

Re: Requirement

Anonymous — Thu, 21 May 2015 05:41:51 GMT

so you want to load other column in Table3 which will have only those values which are not matching with table2 ?

or want to have a column in table1 itself saying these values are not in table2 ?

Thanks

BKC

Re: Requirement

Thu, 21 May 2015 05:44:19 GMT

use left join try this.

ex.

Table1:

load

12345

2345

3456

4567

5679

from

.....

Table2:

left join(Table1)

Load

12345

9876

1234

2345

4567

from

.....

Re: Requirement

Gysbert_Wassenaar — Thu, 21 May 2015 05:46:11 GMT

You can use the Exists() function. A simplified example:

T1:

LOAD * INLINE [

Col1

12345

2345

3456

4567

5678

];

T2:

LOAD * INLINE [

Col2

12345

9876

1234

2345

4567

];

T3:

LOAD Col1

RESIDENT T1

WHERE NOT EXISTS(Col2, Col1);

Re: Requirement

Anonymous — Thu, 21 May 2015 05:50:12 GMT

You can also have left join if you have other columns in tab2

and then filter the records which are not in tab2

see the example

Re: Requirement

kulasekhar — Thu, 21 May 2015 06:33:07 GMT

Thanks

Re: Requirement

kulasekhar — Thu, 21 May 2015 06:44:46 GMT

I have changed in script.

Now write the expression in result column to solve the requirement.

Re: Requirement

kulasekhar — Thu, 21 May 2015 06:49:03 GMT

Hi BKC

I have changed in script.

Now write the expression in result column to solve the requirement.

Re: Requirement

Anonymous — Thu, 21 May 2015 07:26:58 GMT

correct