Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
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
If one condition works, Maybe you can try this
Where Match("Organization", 'Organization A' ,'Organization B');