Search found 219 matches
- Thu Jun 18, 2026 10:42 pm
- Forum: Programming
- Topic: Merging datasets
- Replies: 5
- Views: 4822
Re: Merging datasets
A long overdue thanks, Gareth! Your code takes my handling of the one-to-many case where the key is copied onto the data almost all the way to a quarterly dated page. The final step is fairly simple :-) Now, I'm wondering about the many-to-one case where the data is instead copied onto the key to ar...
- Sat May 30, 2026 2:29 am
- Forum: Programming
- Topic: Merging datasets
- Replies: 5
- Views: 4822
Re: Merging datasets
I think that I have the second case sorted with the code that I posted. But the first case still eludes me. In the end I want to create a quarterly dated page with a range from 1993Q1 to 1997Q4 with the series name_a , ..., name_i . The quarterly values for each series is in the four last columns of...
- Sat May 30, 2026 2:17 am
- Forum: Data Manipulation
- Topic: Simple pageunstack gone wrong
- Replies: 3
- Views: 5457
Re: Simple pageunstack gone wrong
And then loop over the pool name and create the missing series? Something like this: pageload .\test.txt pageunstack name dateid @ value if @isempty(@wlookup("value", "group")) then %crossids = name.@crossids for %crossid {%crossids} copy value value{%crossid} next endif delete n...
- Fri May 29, 2026 9:46 pm
- Forum: Data Manipulation
- Topic: Simple pageunstack gone wrong
- Replies: 3
- Views: 5457
Simple pageunstack gone wrong
I want to import the attached (minimal) text files and unstack them into dated pages with two series: a and b . The text files differ with respect to the value column. The first file (test.txt) has variation in both the name and time dimension (i.e. all unique values), the second (test2.txt) has var...
- Wed May 27, 2026 11:06 am
- Forum: Programming
- Topic: Merging datasets
- Replies: 5
- Views: 4822
Re: Merging datasets
This seems to handle the second case: mode quiet close @all import(page=key) .\key.txt @freq u 1 %name = @wright(@wlookup("*"), 1) rename {%name} name %name = "name" rename series* key* %keys = @wlookup("key*") %objects = @wdelim( _ @wreplace( _ "vintage year "...
- Wed May 27, 2026 4:55 am
- Forum: Programming
- Topic: Merging datasets
- Replies: 5
- Views: 4822
Merging datasets
I'm trying to do either a one-to-many or a many-to-one merge of two datasets (attached). The program file where I try to do it is below. mode quiet close @all import(page=key) .\key.txt @freq u 1 %name = @wright(@wlookup("*"), 1) rename {%name} name %name = "name" rename series* ...
- Thu May 21, 2026 10:24 pm
- Forum: Programming
- Topic: @logmode?
- Replies: 1
- Views: 2310
@logmode?
Is there some way to read the current log mode? (Though I haven't tried personally, I get the impression that it is possible to be writing to several logs at once, which probably complicates matters.)
- Mon May 18, 2026 11:52 pm
- Forum: Programming
- Topic: Weird behavior relating to scope and local subroutines
- Replies: 15
- Views: 44159
Re: Weird behavior relating to scope and local subroutines
Progress? Has the bug been looked into yet?
- Sat May 16, 2026 10:05 pm
- Forum: Programming
- Topic: Get date format for active page?
- Replies: 7
- Views: 4682
Re: Get date format for active page?
Indeed. But then once in a while, it doesn’t. And then it’s harder to build something dependable on it.
- Sat May 16, 2026 8:17 am
- Forum: Programming
- Topic: Get date format for active page?
- Replies: 7
- Views: 4682
Re: Get date format for active page?
I want to be able to take a date string specified in the format of current page and then unambiguously convert that string to a date value.
- Thu May 14, 2026 10:55 pm
- Forum: Programming
- Topic: Get date format for active page?
- Replies: 7
- Views: 4682
Re: Get date format for active page?
By "machine based", do you mean that it depends on the locale of the machine?
- Thu May 14, 2026 10:53 pm
- Forum: Programming
- Topic: Get date format for active page?
- Replies: 7
- Views: 4682
Re: Get date format for active page?
I was thinking date format . On a typical quarterly page, I'd like to get back "YYYY[Q]Q". I have often found code like this %old_date_format = @word( _ "YYYY YYYY YYYY YYYY YYYY YYYY YYYY YYYY YYYY YYYY YYYY " _ + "YYYY[S]S YYYY[Q]Q YYYY[M]MM " _ + "DD/MM/YYYY DD/...
- Tue May 12, 2026 11:45 pm
- Forum: Programming
- Topic: Get date format for active page?
- Replies: 7
- Views: 4682
Get date format for active page?
Is it possible to get the date format of the current page? So that I know that @dateval gives me the correct value.
- Sun May 10, 2026 4:56 am
- Forum: Programming
- Topic: Valid names for options?
- Replies: 1
- Views: 2737
Valid names for options?
Are the requirements for valid option names (“hasoptions” and “equal options”) the same as for object names?
- Fri May 08, 2026 10:25 pm
- Forum: Bug Reports
- Topic: shell not working
- Replies: 0
- Views: 5836
shell not working
When I enter shell in the command prompt, I get the following error message: Unable to create process: Katalognamnet är felaktigt. . It translates to "Fault path name". I think that the error code is ERROR_BAD_PATHNAME. It seems to occur when @datapath refers to a nonexistent folder, which...
