remove contracts comparing two files

[Anonymous]

Hi, everyone

I have two files, "File1" and "File2"

File1:

Contains all contracts

File2:

Contains all contracts that should be excluded

it is possible to remove the contracts in the script?

Example:

All contracts

tab1:

LOAD * Inline [

CONTRACT

1

2

3

4

5

6

7

8

9

10

];

contracts that should be excluded

tab2:

LOAD * Inline [

CONTRACT

1

2

3

4

5

];

Thanks!!

[sunny_talwar]

May be this

tab2:

LOAD * Inline [

CONTRACT

1

2

3

4

5

];

tab1:

LOAD * Inline [

CONTRACT

1

2

3

4

5

6

7

8

9

10

] Where not Exists(CONTRACT);

[its_anandrjs]

Use Where exists.

[Anil_Babu_Samineni]

Where Not Exists(CONTRACT) will achieve

[its_anandrjs]

Do this way based on your table structure

tab2:

LOAD CONTRACT as Exc_CONTRACT;

LOAD * Inline [

CONTRACT

1

2

3

4

5

];

tab1:

LOAD * Inline [

CONTRACT

1

2

3

4

5

6

7

8

9

10

]Where not Exists(Exc_CONTRACT,CONTRACT);

DROP Table tab2;

Find attached