where clause

[#1]

Hi,

I'm trying to run a query with a where clause saying where "YEAR" = '2011' and '2012'; but i keep getting an error message.  What is the correct way of doing this?

Thanks

[#2]

Thanks, but the quote marks work when i only ask to pick up say '726' or '829' on their own but not together

[MayilVahanan]

HI

Please check the attached file..

[Qrishna]

Hi,

You may try creating a small temporary inline table with all required years.

TEMP_YEAR:

LOAD * INLINE [

Year

2014

2015

2016

];

FACT:

LOAD ID,     

           Fact_Date

FROM $(vQVDSourcePath)Facts.qvd (qvd);

Where Exists (Year,Year(Fact_Date));

DROP TABLE TEMP_YEAR;

This logic filters out all the unwanted years except the inline table's years.

and later dropping the temp table leaves with no extra table in the model.

[lawrenceiow]

Might I suggest you try the File Wizard. When you come to the "File Wizard: Options" step you can click the "Where..." button and then make your selections. When you finish you can see how the script was written by the wizard. This will most likely show what went wrong when you tried it.

Most of the answers above are correct:

"SSS_BATCH_ID" = '726' OR "SSS_BATCH_ID" = '829';

or

Match("SSS_BATCH_ID",'726','829')

Both should work so you may find the error is actually something else which the wizard should make apparent to you.