Dynamically Rename a COLUMN pending a specific columns data to the front of the column

[asmith314]

This is a little difficult to explain so I think it would be easier if I show a screenshot

In the sample below, I want to take the value from the ContractYear Column and append it to the column name (I've already ensured that this value is distinct upstream in my workflow). I need to assign it dynamically because my data input is pulling the year dynamically so this could change at runtime. Attached is a sample data file. I tried using the dynamic rename tool but I can't seem to get a formula to do what I need (The formula window in the dynamic input tool isn't as user friendly as the formula tool)

		Current Column Name	New Column Name
ContractYear	Result Name	Value	2021 Value
2021	Cotinine	NEGATIVE
2021	Total Cholesterol	192
2021	HDL Cholesterol	53
2021	LDL Cholesterol	114
2021	Triglycerides	136
2021	Glucose	98
2021	Blood Pressure (Systolic)	130
2021	Blood Pressure (Diastolic)	80
2021	Body Mass Index (BMI)	27.8
2021	Waist Circumference	30
2021	Hemoglobin A1c	4.7
2021	eGFR	63
2021	Creatinine	1.28

[Luke_C · Accepted solution]

Hi @asmith314 

Try this:

[asmith314]

@Luke_C  Worked like a charm! Thanks a bunch