Dynamic Select?

[TaylorMaddox]

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. 

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.

[Hamder83]

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

[Hamder83 · Accepted solution]

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.

[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

[flying008]

Hi, @TaylorMaddox 

Another way for you:

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