Search found 218 matches
- Sat May 30, 2026 2:29 am
- Forum: Programming
- Topic: Merging datasets
- Replies: 4
- Views: 470
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: 332
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: 332
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: 4
- Views: 470
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: 4
- Views: 470
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: 436
@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: 40901
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: 1507
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: 1507
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: 1507
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: 1507
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: 1507
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: 1176
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: 2560
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...
- Thu May 07, 2026 11:13 am
- Forum: Programming
- Topic: How to break out of called program from within subroutine?
- Replies: 1
- Views: 1537
How to break out of called program from within subroutine?
Is there some way in the setup below to break out of child.prg from the subroutine childsub and return to parent.prg? The desired solution would show the dialog box "after child" but none of the other two. parent.prg exec .\child.prg @uiprompt("after child") child.prg call childs...
