Data normalization

Of course it depends what your data looks like. Presumably you need to normalize the data because you're getting a prescribed data feed from an outside system.

Of course it depends what your data looks like. Presumably you need to normalize the data because you're getting a prescribed data feed from an outside system.

But for example, if you had sales coming in on a single record as the records had columns or fields for the 12 months, all in one record that my suggestion is to bring the raw data into a temporary staging table. Then use saved table to table imports to copy those records 12 times into your normalized table, one month at a time. There is very easy syntax to have a pipeline run the same table to Table import, one month at a time. There is very easy syntax to havpipeline run the same table to Table import.

If you give us a better idea of what your non-normalized data look like I can give you more ideas.