Merging 2 workpages

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

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

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: 13600
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

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

Re: Merging 2 workpages

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

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 267 times

EViews Gareth
Fe ddaethom, fe welon, fe amcangyfrifon
Posts: 13600
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.

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

Re: Merging 2 workpages

Postby Andre2016 » Fri Sep 02, 2016 2:48 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.
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 302 times

EViews Gareth
Fe ddaethom, fe welon, fe amcangyfrifon
Posts: 13600
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.

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

Re: Merging 2 workpages

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

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 1 guest