How to exclude loading values from xls files

[lfalmoguera]

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.    

[#2 · Accepted solution]

Exists funtion will do.

table 2:

Load * from xls_file_2

Where Exists(field_5)

Kiran.

[lfalmoguera]

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!

[lfalmoguera]

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!

[lfalmoguera]

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!

[lfalmoguera]

Thanks a lot Kiran!