Skip to Main Content

Integration

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Combining excel spreadsheets

EricDBAEDQFeb 13 2017 — edited Apr 12 2017

I have a configuration like this:

DUPLICATE CHECK------------------------GENERATE WARNING-------------WRITE EXCEL SPREADSHEET

DUPLICATE CHECK------DUPLICATE CHECK------GENERATE WARNING-----WRITE EXCEL SPREADSHEET

LIST CHECK------------GENERATE WARNING------------------WRITE EXCEL SPREADSHEET

Instead of writing 3 separate spreadsheets I want to write all three to one spreadsheet. I tried connecting all outputs from the 'Generate Warning' processor to one 'Write' processor but the spreadsheet that was generated was not right.

It didn't not show all the data. But when I tried the configuration below, it worked just fine:

LENGTH CHECK----------------- LOGIC CHECK--------------LOGIC CHECK-

                                                                                                                     \

                                                                                                                      ----GENERATE WARNING------WRITE SPREADSHEET

                                                                                                                     /

LENGTH CHECK-----------------LOGIC CHECK--------------LOGIC CHECK--

Maybe all the processors used must be the same?

I also tried the 'Merge Data Streams' and that didn't work neither.

This post has been answered by Mike-Matthews-Oracle on Apr 12 2017
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 10 2017
Added on Feb 13 2017
4 comments
267 views