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

[prma7799]

PFA...

Test:

LOAD OGC,

     Dept,

     Date,

     Qty,

     Amount

FROM

(ooxml, embedded labels, table is Sample)

where Match(OGC,'DC' ,'JIN') ;

[jonathandienst]

This works:

LOAD OGC,

     Dept,

     Date,

     Qty,

     Amount

FROM

(ooxml, embedded labels, table is Sample)

Where Match(OGC, 'JIN', 'DC')

[vikas_nandanwar]

This work with excel,

I am using database from SQL server and it gives error with comma (,)

[vikas_nandanwar]

This work with excel,

I am using database from SQL server and it gives error with comma (,)

[petter · Accepted solution]

In a SQL statement you would need to use a different syntax:

SQL

  SELECT

     ......

  WHERE OGC IN('JIN','DC');

[vikas_nandanwar]

Thanks  this worked