Loading Multiple Selections From One Column

[ColtE8]

Hello!

I am trying to load multiple selections from one column. Essentially, I had this to begin with:

FROM [lib://AttachedFiles/Report.xlsx]
(ooxml, embedded labels, table is Exporter)
Where "Organization"='Organization A';

This removed all other organizations from the pull that I didn't want, but now I need to add one more.

I was then trying to do this:

FROM [lib://AttachedFiles/Report.xlsx]
(ooxml, embedded labels, table is Exporter)
Where "Organization"='Organization A' and "Organization"='Organization B';

The second attempt returned 0 lines and didn't work. How do I go about fixing this to where it will load the two organizations I need instead of having to go into the excel file every time I pull the initial report and removing all other orgs that I don't want.

[vincent_ardiet_ · Accepted solution]

You should use an OR, both conditions cannot be true at the same time:
"Organization"='Organization A' OR "Organization"='Organization B'

The other solution is to use a Match function:
Match("Organization",'Organization A','Organization B')>0

[Anil_Babu_Samineni]

If one condition works, Maybe you can try this

Where Match("Organization", 'Organization A' ,'Organization B');