I would like to create a new field for growth rate for another field in the data editor. Is there a way to do this in the script?
This is the script I'm using now to load the data-- I would like to create a new field with a computed growth rate (y/y) for [Alabama].
Date(Makedate([year],right([period],2)), 'M/D/YYYY') as DATE,
Date(Makedate("year",right(period,2)), 'MMMYYYY') as MONTHYEAR,
If(series_id='SMS01000000000000001', value) as [Alabama]
FROM [lib://BLS Employment Series AllData]
(txt, codepage is 1252, embedded labels, delimiter is '\t', msq);
'Employment' as [Series],
SUM([Alabama]) as [Alabama]
Group by MONTHYEAR, DATE;
Drop Table BLS_data_1;