Select Example where example2 = 'Ex1' or 'Ex2' ...

[Anonymous]

I'm trying to load a table called "NAGM" and my code looks like the following-

NAGM:

Select [Manufacturer]

where Manufacturer = "Manu"

and Platform = "HUEY" or "JOHN" or "Eric" or "BENJAMIN" or "CAROL" or "LEE"

FROM [lib://AttachedFiles/Copy Pasted Current Report.xlsx]

(ooxml, embedded labels, table is Sheet1);

What am I doing wrong?

[veidlburkhard]

Hi Nicholas,

the conditions in your where clause should be (Platform = 'HUEY' or Platform  = 'JOHN' or...) see below:

NAGM:

Load

[Manufacturer]

FROM [lib://AttachedFiles/Copy Pasted Current Report.xlsx]

(ooxml, embedded labels, table is Sheet1)

where Manufacturer = 'Manu'

and (Platform = 'HUEY' or Platform  = 'JOHN' or  Platform  = 'Eric' or Platform  = 'BENJAMIN' or Platform  = 'CAROL' or  Platform  = 'LEE')

Hope this helps

Burkhard

[sasiparupudi1]

Where are the year and amount fields being selected in your script?

Please upload a sample excel file with your data so that the guys in the community can better guide you.

Sasi