Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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?
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.
Hi Attitude,
Try the attch application.
I hope this helps
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
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