Using yxdb as input to an Action tool

[calloni]

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

[fmvizcaino]

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

[calloni]

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

[calloni]

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

[DanielBr]

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.

[fmvizcaino · Accepted solution]

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

[calloni]

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