Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

Alteryx Server Discussions

Find answers, ask questions, and share expertise about Alteryx Server.

MongoDB Input - Collections

Scruse314
6 - Meteoroid

Using the MongoDB I am trying to produce a list of Collections and the Workflows/Objects that fall under each Collection.

 

Desired Output: (Example)

CollectionIdName       OwnerIdDateAddedApp/Object Name
1Collection 1123DD-MM-YYYYWorkflow 1
1Collection 1123DD-MM-YYYYWorkflow 2
2Collection 2456DD-MM-YYYYWorkflow 3
2Collection 2456DD-MM-YYYYWorkflow 4

 

 

I have read the documentation in the link below but I'm not still not sure how to proceed it getting the desired output. By Default the MongoDB outputs all nested values from the JSON string into columns but I want tall the nested values as rows.

http://downloads.alteryx.com/betawh_xnext/MongoInput.htm

 

Any help or assistance would be greatly appreciated.

 

Thank you.

7 REPLIES 7
fmvizcaino
17 - Castor
17 - Castor

Hey @Scruse314 ,

 

I suggest you download the Usage Report from the licensing portal. There you will have many examples of interactions between MongoDB collections but also showing how to parse the output properly.

 

 

Best,

Fernando Vizcaino

mathieuf
Alteryx
Alteryx

Hi @Scruse314,

 

A bit messy and not well organized but this should help you

 

mathieuf_0-1638364653431.png

 

somervill
7 - Meteor

This is super helpful Mathieuf! Is this tool may also able to drag collection from a self built mongo db? Namely from a mongo db server not a local server?

mathieuf
Alteryx
Alteryx

Hi @somervill,

 

Yes you should be able to connect to any MongoDB. You might need to change the inputs to match your needs.

somervill
7 - Meteor

Thanks mathieuf!

 

I currently bumped into an new issue. The workflow is able to perform on a Alteryx v2019 version while not able to work on v2022.

 

I've attached the sample workflow, really appreciate if you may have a look!

 

 

mathieuf
Alteryx
Alteryx

I would try to have a simple workflow to start and not an app.

Also try to input user, password into the fields, like below:

 

mathieuf_0-1661845351614.png

 

somervill
7 - Meteor

Yeah, I tried that however it just seems not works on the 2022 version, not quite sure about this. Also have a regualr workflow attached