MongoDB Input Tool: Find distinct values from a column

Question

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?

HiralMavani · Answer

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.

HiralMavani · Answer

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.

Deano478 · Answer

Why not just query your MongoDB collection directly?