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

Question

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

NameValueTopic 21234Topic 35634Topic 43456

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:

Name28/06/202329/06/2023Topic 212344456Topic 356342345Topic 434564567

Many thanks!

binu_acs · Accepted Answer

@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 Answer

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.