Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

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
dennisnet
Valued Contributor III

Re: Help me out to create Link Table!

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?

dennisnet
Valued Contributor III

Re: Help me out to create Link Table!

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
Valued Contributor III

Re: Help me out to create Link Table!

Hi Attitude,

Try the attch application.

I hope this helps

Not applicable

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

Not applicable

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

Community Browser