SSRS – Using Lookup Function for Multiple Column Join

Who is online?  0 guests and 0 members
Home  »  Blogs  »  DevinKnight  »  SSRS – Using Lookup Function for Multiple Column Join
 
3.04
/5
Avg: 3.04/5: (1 votes)

Comments (2)

user041549
user041549 said:
Devin, Thanks for documenting this. Very helpful. Very creative too. Simple solution. I feel kind of silly for not thinking about it before, but we are never to good to learn something! Hermann
10/12/2012
 · 
 
by
vanokap
vanokap said:
Very nice post, Thanks Kevin. I have little bit different situation. I need to do a "OR" join instead of "AND". So , i cannot just concatenate the fields together. For example, I have "IdentityID" and "name" in both the datasets but in one dataset these fields are optional and may be absent. So i want to do a lookup for identitiyID if it exists and Name if it exists.
3/19/2013
 · 
 
by
DevinKnight
DevinKnight said:
Sounds like you may have to get creative with combining IIF expressions with the lookup transform... Something like IIF(identityID = nothing, LOOKUP(...,Name,...),LOOKUP(...,IdentityID,...))
3/20/2013
 · 
 
by
Blogs RSS Feed

DevinKnight's latest blog posts

Blogs RSS Feed

Latest community blog posts