Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
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
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);
Thank you all so much... Problem solved