If your list was in the same Oracle DB (or was somehow generated from it), you could filter using that of course. Under the assumption it's not, you can use data blending to exclude the unwanted IDs.
Attached there is an workbook with an Excel main source, another Excel file that has a subset of customer IDs, and a calc that simply looks for the match of the ID in both sources. With the view shown you can quickly exclude those that don't match. You could also set this to context (to filter prior to any other query), and to global so that every sheet uses the filter.
exclude.twbx.zip 1.1 MB
Worked like a charm, thanks!
Alex Kerin gives the best answer - data blending gives you the most flexibility for updating your list of IDs to filter (include) by simply editing the Excel spreadsheet that is your secondary data source.
However I'd like to remind folks that you can paste in a long list of values to filter directly into the Filter dialog.
- Open the file containing your list of IDs to keep, and copy its contents. Copy only the data, not the column header row if there is one.
- Switch to Tableau.
- Drag the dimension of interest to the Filters shelf.
- Choose the middle radio button option, "Custom Value List".
- Click the text entry box (faint yellow background) and paste your list of IDs directly into the filter box. All IDs will then be placed in your custom value list. Click OK to accept the filter criteria.
I hope folks find this useful,
That's really cool Robert, I had no idea it would accept multiple lines.