Re : Alternate function Available for Exists()

[muniyandi]

Hi All,

Any Alternate function Available for Exists() .

Thanks,

Muni.

[ashfaq_haseeb]

Join

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

Regards

ASHFAQ

[SunilChauhan]

join is not a function its Keyword.

lookup may be for the some extent

[ashfaq_haseeb]

Hi Agree.

But it will replace Exsists() function.

Alternate to Exsists()

Regards

ASHFAQ

[SunilChauhan]

one more i have

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

[muniyandi]

Hi All,

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

Applymap,Lookup

[SunilChauhan]

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

[ashfaq_haseeb]

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

[SunilChauhan]

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;

[muniyandi]

Thanks ASHFAQ,chauhans