Move Data from static columns to a Dynamically created column.

I need help in resolving this issue, that looks straightforward enough. I have the below table and I want to move the 'value' column and 'New Field' column exactly the way they are into 'Forecast April 2023 Flash' and 'April 2003 Actual' respectively. however, because the columns with the month name are created dynamically it names will change every month or every time there is a different data. how can the data be moved without specifically selecting the columns.

Developer

Developer Tools

Input

Common Use Cases

Dynamic Processing

Join

Expression

Accepted answers

BS_THE_ANALYST

@Bwilliams hi, I've attached a workflow for you to test:

It basically replaces the 3rd and 4th column names with [3] and [4]. It then moves the values from [1] -> [3] and [2] -> [4]. Then renames [3], [4] back to what they originally were.

All the best,
BS

CommunityHelp12062023.yxmd

All comments

geraldo

@Bwilliams

Dynamic Select to select the fields through a formula.
If you pass more information like if there are values ??in the other columns for which we choose which will be the best tool to replace the columns you want dynamically.

npariso

Hi @Bwilliams you can use a dynamic rename tool to rename fields containing a specific string. Because those renames will remove the month, you can then use a select tool normally since they will always have the same name.

See below for the dynamic rename formula. Make sure you select all fields for the dynamic rename.

BS_THE_ANALYST

@Bwilliams hi, I've attached a workflow for you to test:

CommunityHelp12062023.yxmd

Bwilliams

@BS_THE_ANALYST

Thanks for the solution. Got a lot of valuable ideas from the other contributors but your solution best solves the issues.

Quick Links

Unanswered
Community Events
Groups

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703