Create new date column with updated data when data run the flow daily

[h12]

I have an alteryx flow created which creates a table like this (from a transpose tool):

Name	Value
Topic 2	1234
Topic 3	5634
Topic 4	3456

Please could you help me work out how I...

• Updating the 'Value' title to today's date
• If I run the flow again tomorrow, it creates another column with the new set of values with tomorrows date:

Name	28/06/2023	29/06/2023
Topic 2	1234	4456
Topic 3	5634	2345
Topic 4	3456	4567

Many thanks!

[binuacs · Accepted solution]

@h12 In your use case you need a backup file to save the records after each run.  Attaching a sample workflow for your reference

In this example I created a backup file with yesterday's date as the heading, the workflow creates the field heading with today's date and appends it to the existing file

[DawnDuong · Accepted solution]

Hi @h12

To change the column name to today's date, you can use the Dynamic rename Tool, under "Formula" mode (see below)

If I understand you correctly, you want to append the next day's column outputs to the previous days? That can be done by Join Tool.

Dawn.

P/S: Maybe I am overthinking it, usually when we want to have different columns for different days, we usually want to summarize obtain summary statistics with the Cross Tab (instead of using Transpose Tool). In such a scenario, you can change data at the input files by appending new records daily and process the file at one go. Just a though.

[h12]

Thank you both! Both solutions worked well.

Dawn - good point re Cross Tab, I think i'll try that as it can append a new record automatically.