Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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

5 Replies
Anonymous
Not applicable
Author

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?

Anonymous
Not applicable
Author

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.

deepakk
Partner - Specialist III
Partner - Specialist III

Hi Attitude,

Try the attch application.

I hope this helps

Not applicable
Author

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

Not applicable
Author

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