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 (3)

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
ajhaynes
ajhaynes said:
Hi Devin, I have been googling around on this process of linking multiple datasets and first, I can't figure out how to get the Lookup to return more than one column, for example I want the date and the value for each patient on my report. But second, I'm not sure, as it sounds like from your post, that using the lookup is the most efficient way. It is most likely that I will have one dataset and then look up 5 different values from 5 different datasets for each row in my original table. Would your approach be to do this in the source SQL query?
4/30/2014
 · 
 
by
DevinKnight
DevinKnight said:
Yes, ideally this would be done in the SQL Query when possible. My circumstance was pulling from two different platforms (Oracle and DB2) and linked servers were not an option.
5/1/2014
 · 
 
by
Blogs RSS Feed

DevinKnight's latest blog posts

Blogs RSS Feed

Latest community blog posts