Exist functionality question

[raju_salmon]

Hi,

I need to filter the data using exists. If i filter data

load

*

from table

where Year=2017;

It is considering as Non-Optimized load.

But i want to load QVD as optimized so i used below

load

*

from table

where Exists (Year, '2017');

But it is throwing an error.

The same syntax available in help. Not sure where its gone wrong.

Can anyone help me how can we filter data using exists function? to keep QVD as optimized?

Thanks,

Raju

[kaushiknsolanki]

Try this.

Temp:

Load * inline [

Year

2017

];

load

*

from table

where Exists (Year);

Regards,

Kaushik Solanki

[Anil_Babu_Samineni]

To which table you are going to Exists() ??

[raju_salmon]

Hi Anil,

I have only table where i need to filter 2017 data with Optimized load.

In help, below information is available but it is not working as expected.

exists(Month, 'Jan') returns -1 (true) if the field value 'Jan' is found in the current content of the field Month.

[raju_salmon]

Can anyone help why below on is not working?

load

Date,

Week,

Month,

Year

from Master_Calendar

where Exists (Year, '2017');

[marcus_sommer]

Why not going with the suggestion from Kaushik? It will work!

To understand more how exists() could be use take a look on last link-block in this posting: Advanced topics for creating a qlik datamodel.

- Marcus

[Anil_Babu_Samineni]

Exists works only fields not field values, So i would suggest to concatenate to dummy table which need like island table