Using yxdb as input to an Action tool
- 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
I've created a tiny workflow that gets the Max date of my products and saves it in a yxdb file:
In another flow I've loaded this yxdb and tried to link it to the Action tool (as input) but Alteryx doesn't seem to like this.
So my question is: how would it be the procedure that does this:
1 - Picks the max date of products from one (or multiple) datasources
2 - Use the max data into the workflow to configure an action tool?
Thanks in advance
Rodrigo
Solved! Go to Solution.
- Labels:
- Interface Tools
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @calloni ,
What will you update with your action tool?
It is not possible to link directly to an action tool, but you can consume the data using a control parameter to update anything else.
Take a look at the example and see if it makes sense to you.
Best,
Fernando Vizcaino
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi Fernando
Here is a bigger picture.
I have a workflow that loads data from several sources. Once the historical load is done I can then only do incremental loads, appending the new data to the hyper file.
The issue I have is that sometimes a source has no new data today so I can't use the "yesterday" date as a fixed parameter. If I ran the process today for example, one of the datasets last date is December 9.
To solve that I am picking the max date for each product and building that little dataset I attached in my question. Then I want to use this to configure the from date to each input tool (some are SQL queries, others are SOQL, Google Analytics, etc) so that I only get data from the last date for each product.
So in theory I have all pieces I need to make the process automatic but I am not sure how to connect the dots now.
Rodrigo
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Oh I got the files now. So the procedure here is to put the workflow inside the macro so I can pass the value from input file into the workflow tools.
I will give it a try now.
Thanks
Rodrigo
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi Rodrigo,
I would put the workflow inside a macro. This will enable you to use the macro input and connect to the action tool
Please mark this as a solution if it solves your problem.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @calloni ,
So the idea is to create a macro where you can get that date using a batch macro.
First I have created a SQL query example as below
Then in the action tool, I select what I want to replace in the query:
And that you can do for every query/connection you have. See attached example and let me know if that works for you.
Best,
Fernando Vizcaino
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
This is awesome Fernando.
Several things I learned here and now I can improve my Macros. I watched a training and I wasn't clear how the replace string in the Action tool worked. Now it is much clear!
Thanks thanks!
Rodrigo
