SAS Data Integration Studio, DataFlux Data Management Studio, SAS/ACCESS, SAS Data Loader for Hadoop and others

can a lookup transformation return multiple rows?

Accepted Solution Solved
Reply
Contributor
Posts: 23
Accepted Solution

can a lookup transformation return multiple rows?

Can a lookup transformation in SAS DI return multiple rows?


Accepted Solutions
Solution
‎11-06-2012 10:36 AM
Super User
Posts: 5,437

Re: can a lookup transformation return multiple rows?

For a single base value, it will return maximum one look-up value (or values if you specified more than on look-up to target mappings).

If your lookup table contains duplicates on the look-up value, it will return the first match.

Data never sleeps

View solution in original post


All Replies
Solution
‎11-06-2012 10:36 AM
Super User
Posts: 5,437

Re: can a lookup transformation return multiple rows?

For a single base value, it will return maximum one look-up value (or values if you specified more than on look-up to target mappings).

If your lookup table contains duplicates on the look-up value, it will return the first match.

Data never sleeps
Respected Advisor
Posts: 4,173

Re: can a lookup transformation return multiple rows?

No. Exactly as Linus explained.

If you want this to happen then you will have to code it (user written transformation) - or you use a SQL join instead.

🔒 This topic is solved and locked.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 676 views
  • 3 likes
  • 3 in conversation