Designer| Dynamic rename of field using another field's first row of data

Question

Hi All,

I have a dataset like below - my goal is to change the field name "Col B" needs to be changed to "27-Sep" i.e., first row of data from another field.

How do I use dynamic rename for this? Can someone guide please?

Col A Col B 27-Sep12327-Sep122

atcodedog05 · Accepted Answer

Hi @Mj9715

Here is how you can do it.

Workflow:

1. Using select tool to get 1st row.

2. Using transpose to get column name and value.

3. Using multi-row formula tool to set new name to Col B.

4. Using dynamic rename to rename the headers.

Hope this helps : )

AngelosPachis · Accepted Answer

Thanks for your reply @Mj9715 .

Here's how you can use the dynamic rename tool to rename column B based on the values of col A.

Hope that helps,

Angelos