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 |
Solved! Go to Solution.
@Luke_C Worked like a charm! Thanks a bunch