Automatically Rename Column if the Values Below Meets Criteria

Hello, is it possible to rename the column if the values below it meet certain criteria? I have tried creating a workflow in order to convert it but am stuck.

I'd like the column to be titled "Username" if it meets all the criteria.

Issue ("Username2" is supposed to still say "val"):

Desired Output:

Desired Output.png

The furthest I've gotten is flagging whether each value meets the criteria but not how to implement the renaming of the header itself since the dynamic renaming formula uses the column heading values and not the fields below it. In addition, I do not want to manually select the specific field to rename or use a filter tool to manually pick the fields, it should be automatic based on the macro/workflow.

Any thoughts on how to achieve this?

DynamicRenameFormula2.yxmd

Workflow

Preparation

Accepted answers

Yoshiro_Fujimori

Hi @courtneyq ,

To keep the order of columns of the original table, I added another flow.

There might be a better way, but I think this is one way.

I hope this helps.

Input

I added another column "Test" to see if the second "good" column works.

Name	val	Test
jsmith	qqqq	abcd
psmith	qadq qq	bcde
wsmith	aaaaaaaaaaaaaaaaaa	defg
asmith	123	fghi

Workflow

Output

Username	val	Username2
jsmith	qqqq	abcd
psmith	qadq qq	bcde
wsmith	aaaaaaaaaaaaaaaaaa	defg
asmith	123	fghi

1282235.yxmd

All comments

Erin

I might not understand completely, but the attached seems to work with the sample...

I added a record ID first. Then I checked the Copy Output Fields and Add box in the multi field formula tool. In the transpose and the crosstab, I checked the box to group by record ID. I reordered the records after the crosstab by the record ID, but maybe you want them to stay sorted by Name? Lastly I renamed the "Name" field to "Username" with a select tool and removed record ID.

DynamicRenameFormula2.yxmd

courtneyq

Thank you for your reply @Erin - My goal is to not rename the heading to "Username" manually since different inputs I use may have the "Username" field titled differently and I am looking to update the field if it falls within my criteria within the Regex formula. My guess is that the potential solution could involve the action tool or the dynamic rename somehow.

Qiu

@courtneyq
I hope I get your intention correctly.

DynamicRenameFormula2-r1.yxmd

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15878

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703