How to Pass Dynamic Date value to MongoDB table

Question

Hello Everyone!

I am using MongoDB Input Tool to connect the MongoDB database. And I want to pass the date value to the table in the Input Tool Dynamically. And the date column showing as String, but I want to pass the date value as the date format. I tried using the JSON format but it works for one value by hardcoding. But I want to pass this dynamically by selecting the value from another stored table.

1. MongoDB Input Tool

2. Pass the date as a dynamic Input

3. Extract the records from the MongoDB table based on this date value

Please share your thoughts, I would appreciate your help on this matter.

Thanks

Ramachandran

mrammail · Answer

Thank you. I will check this further and let you if any questions.

rkapoor · Answer

@mrammail ah I get you now. You can update these parameters via the Interface tools. I knocked up a quick example:

You can then run your workflow as an app in Designer:

or on Server if you have Alteryx Server

mrammail · Answer

Hello RishiK,

Thanks for your response. This will work for general database connections. But I am looking for MongoDB connection. Please check the attached image. I want to pass the 20200911 as dynamically.

Thanks

Ram

Spoiler