How to Pass Dynamic Date value to MongoDB table
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
- Labels:
- Input
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@mrammail can you try to use the Dynamic Input tool to pass through the dynamic SQL?
https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Modifying-SQL-Query-using-the-Dynam...
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thank you. I will check this further and let you if any questions.
