troubleshooting Question

roll up

Avatar of sam2929
sam2929 asked on
DB2
4 Comments1 Solution514 ViewsLast Modified:
Hi,
I have
Source:
Rq_id    event_id   event_code       cust number
1001        create          create              1005
1001         out              
1001         scucess       pickup             2001

So we want to roll up what we want is
Target will have just one row
Rq_id    event_id   event_code       cust number
1001       create         pickup               2001

So basic idea is pickup a row with event_id create and event_code pickup and cust number 2001 and then rollup it to one line only
ASKER CERTIFIED SOLUTION
Kent Olsen
Data Warehouse / Database Architect

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 4 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 4 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros