Replacing Column Headings

[ewassell]

Attached is a spreadsheet that includes Day 1  thru Day 7 RT Hours, Day 1  thru Day 7 OT Hours and Day 1  thru Day 7 DT Hours.  I need to replace the Day # with dates that are reliant on the Period End Date Inputted (going backwards 7,6,5,4,3,2,1) and rename these column names.  Attached is my small workflow because I don't know how to do this and the output I need called outputgood.xlsx.

Thanks in advance for looking at this!

[abacon]

@ewassell This was a little tricky but I have a solution. I am sure somebody else may have a better one but this will work for you.

If this this works for you, please mark it as a solution so others may find it quicker.

[KGT]

I like the response by @abacon that preserves the app interface as it was saved as an app.

I did not preserve the app interface, and have shown 2 methods. One that carries the data, and so you can stop half-way, and one that only deals with the metadata.

With these type of operations, there are many ways to achieve the outcome, and I find it's best to explore a couple, as they may lead to you changing your process. Often a process is only set up in a certain fashion because that's how it was previously in Excel or something else and it can be done quicker and better by re-designing. However, that requires knowing the options available.

[ewassell]

Thank you @abacon.  This did John Doe perfectly but Jane Does totals created new column headings. I need them all to go in the correct columns.

[ewassell]

Thank you @KGTbut without the .yxwz, I can't recreate what you are doing.

[abacon]

@ewassell Could you upload a screenshot of what you are getting? I am running it on my end and it appears to show the correct output. 

[ewassell]

Thanks for getting back to me so quickly!  Here is my output.

[abacon]

What version of designer are you on? and for the Record ID (38) tool, are you able to group by Contractor First Name and Contractor Last Name?

[abacon · Accepted solution]

@ewassell Try this one. I was using the group by functionality on the record ID tool which my guess is a 2024.2 function. This one removes that and does the old way using a multi row tool.

[ewassell]

You Rock @abacon!  Thanks for taking the time to see what was wrong and fixing it so quickly.  You saved me SO much time and I've learned some new things.  I appreciate it!