MongoDB Input Tool: Find distinct values from a column
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
HiralMavani
7 - Meteor
‎03-16-2023
05:17 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi,
I want to find distinct values from a specific column from a MongoDB collection in Alteryx. We do not want to bring all the data in Alteryx and then get distinct. I tried writing queries in Criteria but none of them seem to match the required syntax. Can someone please help me?
3 REPLIES 3
Deano478
12 - Quasar
‎03-16-2023
09:51 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Why not just query your MongoDB collection directly?
‎03-16-2023
11:59 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
We are creating a workflow for users to be able to pull data from MongoDB and helping them setup the workflow. They cannot query the collection directly without Alteryx hence the question.
‎03-16-2023
12:00 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
We are creating a workflow for users to be able to pull data from MongoDB and helping them setup the workflow. They cannot query the collection directly without Alteryx hence the question.
