pageunstack
Posted: Mon Jun 17, 2013 1:59 am
I just cannot seem to get my head around unstacking data. I have a text file (attached) that I have managed to beat in a alpha series containing the identifiers, which have been transformed into names with the code below. The result is saved in the attached workfile.
My next step would be something involving pageunstack and possibly pagestruct which would result in a dated monthyl workfile (start=2013M05,end=2013M05). I cannot seem to get it to work though. Help would be greatly appreciated.
Code: Select all
'Load text file
wfopen "G:\PRO\Map\Arb\Utfall\Ams\Data\Txt\KIS1_201305.TXT" fieldtype=undivided @freq u
'Get date
alpha mydate=@mid(series01,1,4)+"M"+@mid(series01,5,2)
%mydate=@elem(mydate,"1")
delete mydate
'Get id
alpha id=@trim(@mid(series01,7,15))
'Get value
series value=@val(@trim(@mid(series01,22)))
'Delete original data
delete series01
'Construct valid names
alpha name=@makevalidname(id)
delete id