topic Re : Alternate function Available for Exists() in QlikView

Re : Alternate function Available for Exists()

muniyandi — Wed, 06 Aug 2014 06:23:28 GMT

Hi All,

Any Alternate function Available for Exists() .

Thanks,

Muni.

Re: Re : Alternate function Available for Exists()

ashfaq_haseeb — Wed, 06 Aug 2014 06:24:08 GMT

Join

But its preferred to use exsist() instead of join.

Regards

ASHFAQ

Re: Re : Alternate function Available for Exists()

SunilChauhan — Wed, 06 Aug 2014 06:26:21 GMT

join is not a function its Keyword.

lookup may be for the some extent

Re: Re : Alternate function Available for Exists()

ashfaq_haseeb — Wed, 06 Aug 2014 06:29:02 GMT

Hi Agree.

But it will replace Exsists() function.

Alternate to Exsists()

Regards

ASHFAQ

Re: Re : Alternate function Available for Exists()

SunilChauhan — Wed, 06 Aug 2014 06:39:49 GMT

one more i have

apply map is working like exist but limitation is that mapping table must have only 2 fields

Re: Re : Alternate function Available for Exists()

muniyandi — Wed, 06 Aug 2014 07:19:32 GMT

Hi All,

Thanks for reply. can you post sample or example data for above these functions.

Applymap,Lookup

Re: Re : Alternate function Available for Exists()

SunilChauhan — Wed, 06 Aug 2014 07:26:30 GMT

apply map example

Load below amnd see id is lookuped like exists

Maptable:

Mapping

Load * inline [

Id,Name

1,sunil

2,Asfaq

3,Munish

];

Load *,

Applymap('Maptable',Id) as Name;

Load * inline [

Id,Add,phone

1,a,10

2,b,20

3,c,30

Re: Re : Alternate function Available for Exists()

ashfaq_haseeb — Wed, 06 Aug 2014 07:30:44 GMT

Hi,

Try below

//With Where Exsists

Table1:

Load * Inline

[

A,B

1,1

2,2

3,3

];

Table2:

Load * Inline

[

A,B

1,1

2,2

3,3

4,4

5,5

]

Where Exists(A,A);

exit Script;

//With Join Exsists

Table1:

Load * Inline

[

A,B

1,1

2,2

3,3

];

left join

Load * Inline

[

A,B

1,1

2,2

3,3

4,4

5,5

]

Note: this is just example.

Real scenario may wary.

Regards

ASHFAQ

Re: Re : Alternate function Available for Exists()

SunilChauhan — Wed, 06 Aug 2014 08:38:32 GMT

hi see the lookup used like exists

Customer:

Load Text(ID) as ID, Name, Country Inline

[

ID, Name, Country

001, A, Germany

002, B, Italy

003, C, France

004, D, Poland

005, F, Spain

];

Sale:

Load *, Lookup('Country','Name', CustomerName, 'Customer') as Country Inline

[

CustomerName, Sale

A, 100

B, 200

C, 300

D, 260

E, 140

];

Drop Table Customer;

Re: Re : Alternate function Available for Exists()

muniyandi — Wed, 06 Aug 2014 08:58:42 GMT

Thanks ASHFAQ,chauhans

Re: Re : Alternate function Available for Exists()

Wed, 06 Aug 2014 09:05:39 GMT

Take a look at "keep" functions, you can do the same as with exists(),

cheers,

David