How to change table Alias name in Join tranformation

[Riteshdell]

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...

[Kurt_Bremser]

proc sql;
select rd_users.* from users as rd_users;
quit;

[Riteshdell]

@Kurt_Bremser- 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.

[Kurt_Bremser]

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

[jklaverstijn · Accepted solution]

Hi @Riteshdell,

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.

[Riteshdell]

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