Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Guys,
I am pretty sure this must be answered previously but I have not found anything that suits me.
I just want to exclude all "lines" within an excel file where a value of these lines is not within another excel file.
For example:
Table1:
LOAD
field_5
FROM
xls_file_1
WHERE
field_5='YES';
Table2:
LOAD
field_1,
field_2,
field_3,
field_4,
field_5
FROM
xls_file_2
WHERE
field_5 in (Table1);
I cannot find the proper way to perform that "field_5 in (Table1)".
Any idea?
Thanks a lot in advance!
Regards.
Exists funtion will do.
table 2:
Load * from xls_file_2
Where Exists(field_5)
Kiran.
Exists funtion will do.
table 2:
Load * from xls_file_2
Where Exists(field_5)
Kiran.
Mother of God!
I tried that one several times previously...
... but didn´t work.
I just copied yours, and it did!
Time to go to bed.
Thanks a lot Kiran!
Mother of God!
I tried that one several times previously...
... but didn´t work.
I just copied yours, and it did!
Time to go to bed.
Thanks a lot Kiran!
Mother of God!
I tried that one several times previously...
... but didn´t work.
I just copied yours, and it did!
Time to go to bed.
Thanks a lot Kiran!
Thanks a lot Kiran!