Link table creation

[#1]

Hello,

I want to know how to create link table using script.

Please find the attached file for more information.

Thanks

Samir

[#2]

Hi Sravan,

I am getting two different value for 'LoginIDServer' for the same LoginId & Server in LinkTable

Thanks

___________________________________________________________________________

User:

Noconcatenate

Load autonumber(LoginId & Server) as LoginIDServer,

        LoginId,

        Server,

        FullName,

        Emailid

;

LoginDetails:

Noconcatenate

Load autonumber(LoginId & Server & Project_Path) as LoginIDServerProjectPath,

        autonumber(LoginId & Server) as LoginIDServer,

        autonumber(Server & Project_Path) as ServerProject_Path,

LoginId,

Server,

Project_Path,

Access_On,

;

LinkTable:

Load Distinct LoginIDServer,

        LoginId,

        Server,

Resident User;

Drop fields LoginId, Server from User;

***********************************************************************************************

Join(LinkTable) distinct

LoginIDServerProjectPath,

LoginIDServer,

ServerProject_Path,

LoginId,

Server

Resident LoginDetails

;

Drop Fields LoginIDServer,ServerProject_Path,LoginId,Server from LoginDetails;

______________________________________________________________________________________

[#3]

Hello,

I am generating each table using the script in seperate qvw file & storing the output into seperate QVD file.

Thanks

Samir

[#4]

Hi Guess,

sorry for the delay in answering.Autonumber generates a automatic number and I am assuming it might be the cause or may be not. Try this

and if it still does not work. Add an example.

User:

Noconcatenate

Load LoginId & '_' & Server) as LoginIDServer,

        LoginId,

        Server,

        FullName,

        Emailid

;

LoginDetails:

Noconcatenate

Load LoginId & '_' & Server & '_' & Project_Path as LoginIDServerProjectPath,

        LoginId & '_' & Server as LoginIDServer,

        Server & '_' & Project_Path as ServerProject_Path,

LoginId,

Server,

Project_Path,

Access_On,

;

LinkTable:

Load Distinct LoginIDServer,

        LoginId,

        Server,

Resident User;

Drop fields LoginId, Server from User;

***********************************************************************************************

Join(LinkTable) distinct

LoginIDServerProjectPath,

LoginIDServer,

ServerProject_Path,

LoginId,

Server

Resident LoginDetails

;

Drop Fields LoginIDServer,ServerProject_Path,LoginId,Server from LoginDetails;

Hope it helps

Sravan

[paulyeo11]

very good post.