Learning Path 1: Exercise 4: HR

[pdave87]

PE4_workflow attached

[pdave87]

PE4_workflow attached

[ravindrapaidiparthi]

My completed solution

[George_Fischetti]

Practice Exercise 4 solution.

[sgurnule]

Exercise 4: HR

[AngelaKPMG]

exercise4 

[Kris]

Solution Exercise 4

[Hayles]

My solution for practice exercise 4

[orayess]

I took a different approach to this, and would love to hear some insights. Originally, I tried to summarize the combined data streams (grouped by transaction ID and concatenated by urgency and vendor) but i got stuck because my concatenated cells had multiple duplicates within each cell which made it hard for me to flag "N/A" and "Direct Deposit". So, what I did instead is create a filter to only show transaction IDs that are "Direct Deposit" and a vendor of "N/A", and used the unique tool to remove all duplicated transaction IDs.

Same answer, different process. Thoughts?

[orayess]

Forgot to attach my work.