Forum Discussion

sshweky's avatar
sshweky
Icon for Helper III rankHelper III
10 years ago
Solved

filter data on import

I am importing data from Access & Excel. I would like to filter the data I import from each table based on certain criteria. Is there any way I can use the advanced query editor to set a filter based...
  • pqian's avatar
    pqian
    10 years ago

    Can you elaborate a bit on the "based on a specific field & value" part?

     

    in the queries editor, the each column of the table has a drop down button. Clicking on it will bring down a list of distinct values, and you can choose which ones you want to filter out from there.

pqian's avatar
pqian
Icon for Microsoft Employee rankMicrosoft Employee
10 years ago

Can you elaborate a bit on the "based on a specific field & value" part?

 

in the queries editor, the each column of the table has a drop down button. Clicking on it will bring down a list of distinct values, and you can choose which ones you want to filter out from there.

sshweky's avatar
sshweky
Icon for Helper III rankHelper III
10 years ago

Thank you!!!!!!!!!!!