I'm trying to unstack a dataset from SQL, but the data remains a string (instead of a "time series") when I use the unstack command. Could you please take a look on my code?
I've attached the workfile and the code follows here:
Code: Select all
wfopen(type=odbc, timeout=400, wf=temp) zap_beta {%QUERY} @id serie_name @date(start_date) @destid serie_name @date @smpl @all
pageunstack(page=Unstackt,namepat =*_?) serie_name start_date @ datavalue_converted
Many thanks,
Mara