Hi,
I was unable to see the option for a where-based join. I have a case where I want to join two incoming data sets but on a certain condition. Can you tell me how to do that in Centerprise?
Date
Votes
1 comment
-
Ammara Anis Official comment Hi Jean,
We currently don’t have the functionality to support where-based joins directly in Centerprise. But there is a way to get this done. You can apply the join transformation on your data set and then apply a filter transformation to get the effect of a where-based join.
For instance, I have 2 different database tables (Products and Order Details). I want to join the two data sets but only want to get the records where let’s say UnitPrice > UnitPrice_1. (UnitPrice is a field in the Products table and UnitPrice_1 is a field in Order Details table). I can get the desired output by creating a dataflow as follows:
Join the tables on some common key field:
And apply filter condition as follows:
This is how you can perform a where-based join in Centerprise - by using a join and a filter transformation together. Let us know if this workaround isn't clear or you need further help.
Please sign in to leave a comment.