Merging 2 workpages

For questions regarding the import, export and manipulation of data in EViews, including graphing and basic statistics.

Moderators: EViews Gareth, EViews Jason, EViews Steve, EViews Moderator

Andre2016
Posts: 12
Joined: Thu Sep 01, 2016 4:47 pm

Merging 2 workpages

Postby Andre2016 » Thu Sep 01, 2016 5:21 pm

Hello,

I have a workfile with 2 pages and I'd like to merge them into one. Some series in the 2nd page don't exist in the 1st one and I'd like them to be integrated using 3 criteria (here: model, category and country).
Image

I try to use the following command but it does not work:
copy(m) 2000PRSTEVFLEETBYAGE\* 19601999FLEETBYAGE\

Thank you for your help.

EViews Gareth
Fe ddaethom, fe welon, fe amcangyfrifon
Posts: 13306
Joined: Tue Sep 16, 2008 5:38 pm

Re: Merging 2 workpages

Postby EViews Gareth » Thu Sep 01, 2016 7:04 pm

We'll need more information on exactly what you mean
Follow us on Twitter @IHSEViews

Andre2016
Posts: 12
Joined: Thu Sep 01, 2016 4:47 pm

Re: Merging 2 workpages

Postby Andre2016 » Thu Sep 01, 2016 8:29 pm

EViews Gareth wrote:We'll need more information on exactly what you mean


Hi Gareth,

So I have 2 pages in the same workfile :
page1 called "FLEETBYAGE19601999"
Page2 called "FLEETBYAGE20002016"

both pages have the same format and I'd like to merge the two in one page without deleting any data
Thanks
Attachments
sample.WF1
Here is the file
(3.24 MiB) Downloaded 221 times

EViews Gareth
Fe ddaethom, fe welon, fe amcangyfrifon
Posts: 13306
Joined: Tue Sep 16, 2008 5:38 pm

Re: Merging 2 workpages

Postby EViews Gareth » Thu Sep 01, 2016 10:37 pm

Copy them from the source page, Paste Special on the destination page, and use General Match Merge. Then enter the ID series you want to use.
Follow us on Twitter @IHSEViews

Andre2016
Posts: 12
Joined: Thu Sep 01, 2016 4:47 pm

Re: Merging 2 workpages

Postby Andre2016 » Fri Sep 02, 2016 2:48 pm

EViews Gareth wrote:Copy them from the source page, Paste Special on the destination page, and use General Match Merge. Then enter the ID series you want to use.


Thanks Gareth.

The issue is when I try to do that, since my old and new data have the same name (for example in the attached workfile, I have "year" in both pages) the first one is erased.

is there a command so that when I paste year from page 1 to page 2 the two are merged ?

So far I used the following command unsuccessfully :

copy(m) FLEETBYAGE20002016\year FLEETBYAGE19601999\
Attachments
forecast.wf1
(963.43 KiB) Downloaded 254 times

EViews Gareth
Fe ddaethom, fe welon, fe amcangyfrifon
Posts: 13306
Joined: Tue Sep 16, 2008 5:38 pm

Re: Merging 2 workpages

Postby EViews Gareth » Fri Sep 02, 2016 5:27 pm

When you do the copy/paste it will ask you if you want to merge the objects.
Follow us on Twitter @IHSEViews

Andre2016
Posts: 12
Joined: Thu Sep 01, 2016 4:47 pm

Re: Merging 2 workpages

Postby Andre2016 » Fri Sep 02, 2016 10:41 pm

EViews Gareth wrote:When you do the copy/paste it will ask you if you want to merge the objects.


I solved the issue using pageappend.

Thanks


Return to “Data Manipulation”

Who is online

Users browsing this forum: No registered users and 23 guests