Icon

Dynamically changing column headers with calendar years

Dynamically rename column headers with calendar years. This does not take into consideration what the original column headers are. This is specific to the request, and there are some assumptions that are made:
1. There are x2 the amount of columns of the number of years needed (the years + the spend columns)
2. The columns to be renamed are in the order of the years, and the years columns are first, followed by the spend columns

Node 1Node 2Node 3Node 4Node 8InitializeRowIDNode 10Convert Yearcolumn toStringNode 12Generate "Spend"Append the"Spend"InitializeRowIDTable Creator Create Date&TimeRange Extract Date&TimeFields Column Filter Extract Table Spec RowID Joiner Column Rename Insert ColumnHeader String Manipulation Concatenate RowID Node 1Node 2Node 3Node 4Node 8InitializeRowIDNode 10Convert Yearcolumn toStringNode 12Generate "Spend"Append the"Spend"InitializeRowIDTable Creator Create Date&TimeRange Extract Date&TimeFields Column Filter Extract Table Spec RowID Joiner Column Rename Insert ColumnHeader String Manipulation Concatenate RowID

Nodes

Extensions

Links