How to Create a Dynamic Pivot in Dataflow ?
I have a dataset that I would like to pivot on a certain column value, development month, that introuduces new unique values each time the data is refreshed.
The issue that I am having is that this field can change any time the dataset is updated. This is a rather large data set (2 million rows) and I'd like to avoid having to go in every month and figure out if there were new values added.
Also, the pivot columns should be a running total meaning that column 3 should be the sum of all values 1, 2, and 3. Column 6 should be the sum of all values from columns 1, 2, ,3 ,4 ,5 ,6. I would like this to be dynamic so that if I load the dataset today and there is new development month, say 84, then this is added as a column and the values from 1-84 summed as the value.
Any ideas how to do this in DOMO? I know how to do this is MSSQL but not in MySQL or Magic ETL.