Dynamically change column headers each day ran

Question

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.

ShankerV · Accepted Answer

Hi @JSheppard98

Workflow:

Step 1: Input

Step 2:

Creating another text input

Step 3: Formula tool

Step 4: Generate rows

ShankerV · Accepted Answer

Hi @JSheppard98

Step 5: Formula tool

Step 6: Filter

Step 7: Formula tool

step 8: Transpose tool

ShankerV · Accepted Answer

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 Answer

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

ShankerV · Accepted Answer

Hi @JSheppard98

Yes, Its possible.

Please see my input below.

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 Answer

Hi @JSheppard98

You can achieve the rename after leaving the first 2 columns by below.

Many thanks

Shanker V

ShankerV · Accepted Answer

Hi @JSheppard98

Logic followed is splitting the first 2 columns

Then remaining all are send for dynamic rename.

Post rename both are joined with the join tool.

Added step : Record ID tool

Nest step: Select tool

Next step: Select tool

Nest step : Record ID tool

Final one is the Join tool,

Expected result:

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 Answer

Hi @JSheppard98

Sorry to be a pain, but was still getting the "2" at the end of some column headers and also instead of the +1 and +2 days columns to be movements and closing balance like below they aren't. Unsure where abouts I am going wrong RE the join tool part

I am unable to understand the above, can you please explain little elaborately.

Happy to help!!!!

Many thanks

Shanker V