topic Re: How to exclude loading values from xls files in QlikView

How to exclude loading values from xls files

lfalmoguera — Fri, 20 Jul 2012 00:43:50 GMT

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.

Re: How to exclude loading values from xls files

Fri, 20 Jul 2012 00:47:58 GMT

Exists funtion will do.

table 2:

Load * from xls_file_2

Where Exists(field_5)

Kiran.

Re: How to exclude loading values from xls files

lfalmoguera — Fri, 20 Jul 2012 00:53:03 GMT

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!

Re: How to exclude loading values from xls files

lfalmoguera — Fri, 20 Jul 2012 00:53:10 GMT

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!

Re: How to exclude loading values from xls files

lfalmoguera — Fri, 20 Jul 2012 00:53:27 GMT

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!

Re: How to exclude loading values from xls files

lfalmoguera — Fri, 20 Jul 2012 00:53:41 GMT

Thanks a lot Kiran!