Filters at the opening of APP

[vikas_nandanwar]

Hi,

I have a group of data where i have regions as one of the column header

Like

OGC

JNY

JIN

JAN

JIS

JCN

DC

JHK

I wan't a filter at the start with JIN and DC

I am using single below expression for single filter in Data Editor -

Load [ODC], [Date], ... from [Lib://...] *ooxml, ...) Where OGC = 'JIN';

But for multiple filter this donot work -

Load [ODC], [Date], ... from [Lib://...] *ooxml, ...) Where OGC = 'JIN' OR 'DC';

this donot work.

Please help.

Thanks,

Vikas

[lovekeshs]

Where OGC = 'JIN' OR OGC= 'DC';

I am sure you have tried like this as well!

[prma7799]

use this

Load [ODC], [Date], ... from [Lib://...] *ooxml, ...) Where match(OGC , 'JIN' OR 'DC') ;

[vikas_nandanwar]

It gives me OR Function error

[prma7799]

Try this

Load [ODC], [Date], ... from [Lib://...] *ooxml, ...) Where match(OGC , 'JIN' , 'DC')

[vikas_nandanwar]

Match function also do not work

[prma7799]

Try this

Load [ODC], [Date], ... from [Lib://...] *ooxml, ...) Where wildmatch(OGC , 'JIN' , 'DC')

[vikas_nandanwar]

Wildmatch function also not getting recognised

[prma7799]

Please share some sample data.

[vikas_nandanwar]

Hi,

I am sharing excel with you

I want data for

JIN and DC

Thanks,

Vikas