Removing matching values

[#1]

Hi all,

Till now I have worked with joins and worked out well.

Now i have an opposite use of it.

I have two Excel Tables:

Lets say

One:

the field Alphabets and having values from a to z

Second:

The Field Vowels having values a,e,i,o,u

Now I want to remove the vowels from my table One without hardcoding.

Can I implement it in the load script in a way?

Thanks in advance

[kaushiknsolanki · Accepted solution]

Hi,

First Load the one which you want to remove, so in your case Vowels.

Then load second table from where you want to remove, in your case a to z.

Then use the exists function.

Sample script will be.

Load Vowels from xyz.

Load Alphabets from pqr where not exists (Vowels,Alphabets);

Regards,

Kaushik Solanki

[ashfaq_haseeb]

Hi

Try like this

Vowels:

Load * Inline

[

Field1

A

E

I

O

U

];

Alphabet:

load * Inline

[

Field2

A

B

C

D

E

F

G

H

I

J

K

L

M

N

O

P

Q

R

S

T

U

V

W

X

Y

Z

]

Where not Exists(Field1,Field2);

Regards

ASHFAQ

[er_mohit]

Yeah you can use where exist function for your case

first load the table which have vowels then load another tables which have data upto a to z. then use where not exist function.

try below script

Table1:

LOAD * Inline [

F2

a

e

i

o

u

]

;

Table2:

LOAD * Inline [

F1

a

b

c

d

e

f

]Where not Exists(F2,F1);

[#5]

Thank you all so much... Problem solved