• 'Lookup' didn't work as I couldn't figure out how to use parameters in 'lookup'. but I was able to get the result by using 'Merge Join' and 'Conditional Split' 🙂