Using yxdb as input to an Action tool

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

Interface Tools

Accepted answers

fmvizcaino

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

2019-12-18 Using yxdb as input to an Action tool.yxmd

2019-12-18 Using yxdb as input to an Action tool.yxmc

All comments

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

2019-12-18 Using yxdb as input to an Action tool.yxmd

2019-12-18 Using yxdb as input to an Action tool.yxmc

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

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703