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

[Mj9715]

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-Sep	123
27-Sep	122

[atcodedog05 · Accepted solution]

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]

Hi @Mj9715 

In your data, do you have other records with dates under Col B? So something like the table shown below?

Col A	Col B
27-Sep	123
27-Sep	122
30-Sep	159
30-Sep	160

If yes, what do you want to do with this extra rows? Also how do you want ColA to be renamed?

Thanks,

Angelos

[Mj9715]

@AngelosPachis - Col A consists of a single date., i.e.,only 27-Sep for eg. 

Col A name can be retained as is. However, the data corresponding to the date contained in column A (i.e., daily file) needs to be Col-B's field name. 

[AngelosPachis · Accepted solution]

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