How to remove fields from MongoDB input query in Alteryx?

[tinker]

Hi Team,

I’m working with the MongoDB Input tool in Alteryx Designer, and I have a query that returns around 21 fields. However, I only need a few specific fields for my workflow.

Is there a way to exclude or select only certain fields directly in the MongoDB query, instead of pulling everything and filtering with the Select tool?

[davidskaife]

Hi @tinker 

The MongoDB Tool has been depreciated by Alteryx, and they recommend using a standard Input Data Tool, and an ODBC Driver - https://help.alteryx.com/current/en/designer/data-sources/mongodb.html

Using the Input Data Tool should allow you to select just the columns you need using the Visual Query Builder (or by writing out the SQL as required) prior to pulling it into Alteryx.