Update input with another one dynamically

Hello!

I have one workflow that gives me the max_date of a table.

Later in the process, I need to update a part of another string that contains the old date with this new max_date.

For example, let's say that the first workflow gives me a max_date = 09/21/2022 and the other input has a max_date = 09/20/2022. Then, I would need to dynamically update the second string (that later I'll use to build a query) with this new max_date.

I was using the action tool but I wasn't able to achieve what I need.

Any ideas on how to do that?

Thanks!

Workflow

Input

Salesforce

Iterative Macro

Accepted answers

DataNath

@matheusld2 you could place your SF input inside a batch macro and have your max_date feed a control parameter that then goes through an action tool to update the date part of the query that needs changing. Not sure how experienced you are with batch macros but there's a load of community resources out there, including this as a good starter/intro: https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Getting-Started-with-Batch-Macros/ta-p/488165

All comments

DataNath

@matheusld2 are you able to give a bit more information on how these two processes interact? Are they 2 different parts of the same workflow or separate workflows altogether? If you can provide what you've attempted so far - perhaps with some mocked up data if your actual is sensitive - or at least some screenshots etc that'd be great and help us to provide a solution quicker!

matheusld2

So, this is a sample from my workflow ->

Contacts Date Query return a date that I have to use to update the where clause of my Salesforce input.

Any ideas on how to do this ?

Thanks!

DataNath

FreeRangeDingo

If Sales Force could be queried with a dynamic input, I'd say switch to that. But, I would guess that is not possible. I think @DataNath is right.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703