topic Re: Help me out to create Link Table! in QlikView

Help me out to create Link Table!

Tue, 14 Jun 2011 10:36:52 GMT

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!

Anonymous — Tue, 14 Jun 2011 11:44:36 GMT

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!

Anonymous — Tue, 14 Jun 2011 11:51:03 GMT

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!

deepakk — Tue, 14 Jun 2011 16:43:11 GMT

Hi Attitude,

Try the attch application.

I hope this helps

Re: Help me out to create Link Table!

Thu, 16 Jun 2011 07:13:11 GMT

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!

Thu, 16 Jun 2011 07:19:51 GMT

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