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

How to change table Alias name in Join tranformation

Accepted Solution Solved
Reply
Contributor
Posts: 63
Accepted Solution

How to change table Alias name in Join tranformation

Hi all,

Can any one tell me that , How we can change table Alias name Inside Join transformation.

 

 

Exp.  I have a table called name "USERS".

 

In join transformation , when we give the join condition then it should change ALias Name.

like : RD_USERS.

 

can any body help me quickly....?

 

Thanks in advance...

 

 


Accepted Solutions
Solution
‎06-07-2016 03:31 AM
Super Contributor
Posts: 408

Re: How to change table Alias name in Join tranformation

Hi @Ritesh_dellvostro,

 

If this is DI Studio, open the Join by double-clicking it and have a look at the Navigate tree in the side bar. If you click on a table in the From yhou will see the propereties of that table underneath. There is an Alias property available. That will cause your SQL to go like "FROM Table1 T1" ...

 

Hope this helps,

- Jan.

View solution in original post


All Replies
Super User
Posts: 6,963

Re: How to change table Alias name in Join tranformation

proc sql;
select rd_users.* from users as rd_users;
quit;
---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
Contributor
Posts: 63

Re: How to change table Alias name in Join tranformation

@KurtBremser- I need in this in transformation setting, some where in Join transformation. it is there.

 

But right now, I am unable to find it.

 

PS: I dont need through coding.

Super User
Posts: 6,963

Re: How to change table Alias name in Join tranformation

When defining a query in Enterprise Guide, right-clicking on the source table lets one select "Options", and there one can change the alias.

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
Solution
‎06-07-2016 03:31 AM
Super Contributor
Posts: 408

Re: How to change table Alias name in Join tranformation

Hi @Ritesh_dellvostro,

 

If this is DI Studio, open the Join by double-clicking it and have a look at the Navigate tree in the side bar. If you click on a table in the From yhou will see the propereties of that table underneath. There is an Alias property available. That will cause your SQL to go like "FROM Table1 T1" ...

 

Hope this helps,

- Jan.

Contributor
Posts: 63

Re: How to change table Alias name in Join tranformation

@jklaverstijn-- Thanks for your correct help.. I got it....

☑ This topic is solved.

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

Discussion stats
  • 5 replies
  • 423 views
  • 3 likes
  • 3 in conversation