Update input with another one dynamically

[matheusld2]

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! 

[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 · Accepted solution]

@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/t...

[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.