MongoDB Input Tool: Find distinct values from a column

[HiralMavani]

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?

[Deano478]

Why not just query your MongoDB collection directly? 

[HiralMavani]

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]

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.