how to create longitudinal/historical data from frequent data dumps?

[johand_erst]

How do I create a longitudinal dataset, meaning that each observation, or unit of analysis, has one row per each point in time the Alteryx workflow runs?

It has to create a time-col and add rows per time for each observation identified with a known ID variable.

I plan using a runner in a seperate workflow to control the times with which the above gets done. I expect it to be a weekly, automatic procedure.

The dataset that I wish to utilize to create historical data is stored in a .csv file which gets updated daily.

[johand_erst · Accepted solution]

Perhaps one solution is as follows

take the data at T0, generate a variabel with a time stamp

next time, append the data and generate a new value to the time-variable