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.
Solved! Go to Solution.
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.
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
Hi @JSheppard98
Workflow:
Step 1: Input
Step 2:
Creating another text input
Step 3: Formula tool
Step 4: Generate rows
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
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