topic Re: Dynamic Select Formula - Select all fields from left join and any matching right join in Alteryx Designer Desktop Discussions

Dynamic Select Formula - Select all fields from left join and any matching right join

taschmies — Tue, 10 Jun 2025 15:42:26 GMT

Hi all,

I'm working on a workflow that will take in a budgeted number of reports per week and will compare it with the actual number of reports per week, then adjust the budget accordingly. Since I need this workflow to be dynamic and work for any given weeks and any given number of weeks, I'm trying to use the dynamic select tool.

In the attached image you can see the layout of how the fields in the join will look. I will be joining on category, then I need to select all the fields from the left side which are the actuals. These column values will be changing week over week. Then I need to select all the fields from the right side (the budget) that match, so any field containing "right" in the rename.

I need help writing a formula for the dynamic select tool which will do as I described above. Here are the specific steps:

1. Select all left fields

2. Select all matching right fields

3. rename left fields to "actual" + week range

4. rename right fields to "budget" + week range

I would upload the workflow for ease of use, but it's very large and contains sensitive information. Thank you in advance for any help or guidance! Please let me know if you have any questions.

Re: Dynamic Select Formula - Select all fields from left join and any matching right join

atcodedog05 — Tue, 10 Jun 2025 15:57:39 GMT

Hi @taschmies,

Can you atleast provide a 5 row randomized data.

Re: Dynamic Select Formula - Select all fields from left join and any matching right join

binu_acs — Tue, 10 Jun 2025 16:08:09 GMT

@taschmies created a workflow based on my understanding. if you are looking for a different output, then provide sample data and expected result as @atcodedog05 mentioned

Re: Dynamic Select Formula - Select all fields from left join and any matching right join

taschmies — Tue, 10 Jun 2025 16:08:37 GMT

Here is an example to go off of

Re: Dynamic Select Formula - Select all fields from left join and any matching right join

binu_acs — Tue, 10 Jun 2025 16:16:32 GMT

@taschmies updated workfllow attached

Re: Dynamic Select Formula - Select all fields from left join and any matching right join

taschmies — Tue, 10 Jun 2025 16:20:14 GMT

I opened your file, and I think it's the same one I uploaded. Can you try reuploading your changed version? Thanks!

Re: Dynamic Select Formula - Select all fields from left join and any matching right join

atcodedog05 — Tue, 10 Jun 2025 16:22:55 GMT

Hi @taschmies ,

Here is my take on it.

Hope this helps : )

Re: Dynamic Select Formula - Select all fields from left join and any matching right join

binu_acs — Tue, 10 Jun 2025 16:23:57 GMT

@taschmies

Re: Dynamic Select Formula - Select all fields from left join and any matching right join

taschmies — Tue, 10 Jun 2025 16:38:36 GMT

@atcodedog05 thank you, this worked as intended in my actual workflow! @binu_acs thank you for your assistance as well!

Re: Dynamic Select Formula - Select all fields from left join and any matching right join

atcodedog05 — Tue, 10 Jun 2025 16:40:31 GMT

Happy to help : ) @taschmies

Cheers and have a nice day!