Combining fields from two worksheets into one worksheet [message #158978] |
Wed, 15 February 2006 05:28 |
DiscoWriter
Messages: 4 Registered: January 2006
|
Junior Member |
|
|
Dear All,
Please help. I have a worksheet each for payables and receivables which have the same columns headings. I now want to create a 3rd worksheet, which would combine the values in the 2 worksheets. Note that all the worksheets are in a single workbook. I'm on Discoverer Plus 10g.
E.g.
Payables Worksheet
Prj Num.....Amount........Date
A12........ 500...........13Feb06
Receivables Worksheet
Prj Num.....Amount........Date
A12.........400...........14Feb06
A13.........250...........15Feb06
Combined Worksheet
Prj Num.....Amount........Date
A12.........500...........13Feb06
A12.........400...........14Feb06
A13.........250...........15FEb06
I'd be grateful for any help/advice/code you can share on this topic.
|
|
|
Re: Combining fields from two worksheets into one worksheet [message #159804 is a reply to message #158978] |
Tue, 21 February 2006 13:07 |
skooman
Messages: 913 Registered: March 2005 Location: Netherlands
|
Senior Member |
|
|
Hi,
I would say the only way is to create a view (in the database or in a custom folder in the EUL) with a UNION statement in it. Than use that one in the third sheet.
But maybe someone else has a suggestion?
By the way, I think one of the types (receivables or payables) should be in negative in the combined sheet.
Regards,
Sabine
|
|
|
|