Dynamic Select?

Hello everyone!

I'm building a workflow where I'm reading in a file that contains numbers for store based on period.

Here's what the input looks like.

2023-07-12 11_43_49-New Message - Alteryx Community and 6 more pages - Work - Microsoft Edge.png

I would want to append a field that says what period it is and have the workflow select only the column with the corresponding period while maintaining the column with the store numbers.

Here's what I want the output to look like if it was period 3.

I was thinking I would be able to use dynamic select for this, but I can't figure out a way to achieve this outcome.

Workflow

Common Use Cases

Accepted answers

Hamder83

Maybe something like this?

All comments

Hamder83

Do you have the period in the file, or from where should i get it?

Hamder83

Maybe something like this?

TaylorMaddox

Thank you so much! That helped a lot I didn't even think of the transpose tool! This achieved what I was trying to do.

2023-07-12 13_11_41-Alteryx Designer x64 - TruckRollfoward.yxwz_.png

danilang

Hi @TaylorMaddox

You're on the right track with the Dynamic Select. You just need a bit of pre and post meta data manipulation

The bottom Text Input holds the target field name and WorkingName field with value "SelectedPeriod". The first Dynamic Rename renames the target field to the SelectedPeriod. The Dynamic Select selects the Store field and SelectedPeriod. The second Dynamic rename restores the original Target name

Dan

DynamicSelect.yxmd

flying008

Hi, @TaylorMaddox

Another way for you:

录制_2023_07_13_10_48_14_396.gif

BTW, if value of each row are not same by field [Period] , then:

录制_2023_07_13_11_54_46_221.gif

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703