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.
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
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.
