5 Replies Latest reply: Jun 16, 2011 3:24 AM by At titude RSS

    Help me out to create Link Table!

      Hi All

       

      1. We wants to connect User and Logon table with both the fields(A and C). Need to concatenate!

       

      2. For your information, Calendar and Logon table are connected with field F. This connection is must.

       

      3. We wants to connect Calendar and User with the field 'Month'. But If do so then we will get circular reference which may cause problem.

       

      To avoid this I think we need to use the link table. As I have never done this before can some one do the required changes in the sample application please. Attach the same once the changes are done please!

       

      If you need anything please do let me know.

       

      Thanks

       

      Attitude

        • Re: Help me out to create Link Table!
          Dennis Hoogenboom

          Hi There,

           

          To start with 1, there you should combine A and C to a new key field, something like:

           

          A & '-' & C as KEYAC

           

          Do this for User and for Logon. Then drop or rename the original A and C field in User (or in Logon) , like

           

          A as UserA,

          C as USerC,

          Month as UserMonth

           

          If you reload this you will see that your tables User and Logon are connect only on 1 field.

           

          I don't know what F is but you should find a solution like this for that also.

           

          Let me know if this is any help ok?

            • Re: Help me out to create Link Table!
              Dennis Hoogenboom

              After you renamed the fields and created the keyfields, I think it is best to join the User and Logon data.

              You can do that something like this:

               

              User:

              LOAD * INLINE [

                   KEYAC, B, MonthUser

              ];

               

              Logon:

              Join (User)

              LOAD * INLINE [

                  F,  KEYAC, FKEY

              ];

               

               

              Calendar:

              LOAD * INLINE [

                  FKEY, Year, Quarter, Month, Week

               

              I assume that F is your date field? In that case you don't need to make a Key out of F and Month.

                • Re: Help me out to create Link Table!

                  Hi Dennis

                   

                  Thanks a lot for your help! I am still trying with the solution that has been provided. While doing that I have come across some new doubts.

                   

                  Doubt is: Instead of joining the User table I have joined the Logon table as highlighted below in BOLD. Will it behave in the same way? Please do let me know!

                   

                  User:
                  Join (Logon)
                  LOAD * INLINE [
                       KEYAC, B, MonthUser
                  ];
                  
                  Logon:
                  LOAD * INLINE [
                      F,  KEYAC, FKEY
                  ];
                  
                  
                  Calendar:
                  LOAD * INLINE [
                      FKEY, Year, Quarter, Month, Week
                  
                  


                  Thanks

                   

                  Attitude

                • Re: Help me out to create Link Table!

                  Hi Dennis

                   

                  Can you please suggest me someway of doing the same using a Link Table. As I have never done that not sure how to do. Please help me out when you find free time!

                   

                  Also we want to connect Calendar and User table with field Month as mentioned in Point 3 of my requirement.

                   

                  Thanks

                   

                  Attitude

                • Re: Help me out to create Link Table!
                  Deepak Kurup

                  Hi Attitude,

                   

                  Try the attch application.

                   

                   

                   

                  I hope this helps