cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
spuckle
‎01-08-2018
  • 2 Posts
  • 2 Likes Given
  • 0 Solutions
  • 1 Likes Received

Re: DI Studio - UNION

by Calcite | Level 5 in SAS Data Management
‎01-05-2018 06:54 AM
1 Like
‎01-05-2018 06:54 AM
1 Like
I'm familiar with how to do it in SQL - in fact it's what I'm rebuilding in DI (for data lineage purposes).   UNION is under the SQL "Join" transformations in DI Studio   The SELECT node above is where columns are mapped, obviously in a UNION we have both sources populating a single column in the target table, which DI appears not to allow. ... View more

DI Studio - UNION

by Calcite | Level 5 in SAS Data Management
‎01-05-2018 06:19 AM
‎01-05-2018 06:19 AM
Hi,   I have a couple of problems I need some help with:   I've two tables with identical in columns that I want to UNION together - I'm using the SQL JOIN transformation, however I'm stumped on the Mappings tab.  It appears you can only map one of the sources to the target, thus ignoring that it is a UNION.    I am also having issues with a CASE statement in the Target table - the CASE wizard allows you to select a column in the target table, however this errors when running.  The error states an ambiguity as the same column name is in the two source tables even though I choose the target as the source.   I'm using DI Studio 4.9   TIA,   Gordon   ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎01-08-2018 01:23 PM
Likes given to
View All
Likes from
View All
Quick links