Dynamically change column headers each day ran

[JSheppard98]

Hi there,

I am wanting to try and change the below which would be column headers for my input data. This would ideally be ran daily, and columns A and B would be the current day, columns C and D would be the next working day (+1 from current day, unsure how to get around skipping weekends as would only want to count "workdays" as Mon-Fri) and then Column E and F (+1 from columns C and D).

Is this possible in Alteryx? As I am able to use "DateTimeFormat(DateTimeToday(),'%d/%m')+' Balance'" for columns A and B to rename those but unsure how to proceed with the other columns.

Please let me know if you require anything further.

[FinnCharlton]

Hello, here is one way of doing this. This will work as long as the workflow is run on a weekday. You can edit the calculations so they say "Movements" when they should

[JSheppard98]

Hi Finn, thanks for the quick response. This seems to work but fills the rest of the column with the wanted header column. I've used the dynamic rename tool to take field names from the first row of data for these columns I want to dynamically change each workday ran. 

[grazitti_sapna]

@JSheppard98 , This is what I figured out as per your requirement.

[ShankerV]

Hi @JSheppard98 

Please find the below expected output.

Input was:

As per your expectation, all the headers will be modified ignoring the weekends.

If this helps, please like this post and mark it as a solution. If you have any other questions, please let us know.

Many thanks

Shanker V

[binuacs]

@JSheppard98 One way of doing this#

[ShankerV · Accepted solution]

Hi @JSheppard98 

Workflow:

Step 1: Input

Step 2:

Creating another text input

Step 3: Formula tool

Step 4: Generate rows

[ShankerV · Accepted solution]

Hi @JSheppard98 

Step 5: Formula tool

Step 6: Filter

Step 7: Formula tool

step 8: Transpose tool

[ShankerV · Accepted solution]

Hi @JSheppard98 

Step 9: Select tool

step 10: Dynamic rename

Output:

If this helps, please like this post and mark it as a solution. If you have any other questions, please let us know.

Many thanks

Shanker V

[ShankerV · Accepted solution]

Hi @JSheppard98 

The workflow shared is very dynamic where the data's in the table will not get affected but it will dynamically rename the column header.

Please find the below output.

Input: 

If this helps, please like this post and mark it as a solution. If you have any other questions, please let us know.

Many thanks

Shanker V