SOLVED
Possible to use a file as a "not in" filter?
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
jensroy
9 - Comet
‎09-16-2016
12:27 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi,
I am wondering if it is possible to use fields in one file as a filter for fields in another file. I have a list of 50 values that I want to filter out of a file that has X million rows. Currently I am using the "Right-side" output of a join, but I hope to find a faster way. The sample workflow attached has 500 rows of data.
Any ideas on how to optimize this would be very appreciated!
Solved! Go to Solution.
3 REPLIES 3
ACE Emeritus
‎09-16-2016
01:13 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
‎09-16-2016
02:35 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thanks a lot, that worked like a charm.
Also, congratulations on winning the Grand prix Mr. Community! :D
ACE Emeritus
‎09-16-2016
03:02 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
hehe. Thanks.
