how to filter the data with where condition

[madhubabum]

Hi all

I have FY2001,FY2002,FY2003,FY2004,FY2005 data set,

how can i get FY 2003 to FY 2004.......with the help of Where condition

Thanks

Madhu

[MK_QSL]

If you want at script level

Load * From TableName Where WildMatch(Year,'*2003',*2004);

If you want at front end

Something like below

SUM({<Year = {'*2003','*2004'}>}Sales)

[#3]

Hi Madhu,

You can use

Where wildmatch(Year,'FY2003','*2004');

Thanks,

Garry

[jsingh71]

Load *  From …..   WHERE Match(Year, ‘2003’, ‘2004’)

[madhubabum]

Hi jsingh

Thanks to ur reply

I want to filter the data from "June-2003" to "may-2004"

[#6]

Hi Madhu,

Load .... From ..... where Year>2003; this will give year from 2003 to......

[jsingh71]

what is your Date field? Is there a field is available which contains values like June-2003, July-2003 and so on?

[jsingh71]

Or share some sample data so its easy for us to give you correct solution.

[krishna20]

Hi Madhu,

if you need to display 2003 & 2004 data at front end. Try MRKachhiaIMP

Second suggestion.It will works.

[vcanale]

Hi,

Try this:

Load 'AllFieldsYouNeed',

Date(MonthStart('YourDateField'), 'MMM-YYYY') as [MMM-YYYY]

from TableName

where  [MMM-YYYY] > Jun-2003 and [MMM-YYYY] <May-2004;