Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have two tables.
In one table i have A,B,C,D.....K
In second table i have A,B,C,D,L.
Now i need to use combination of A,b,C,D(from 1st table if i don't use A,B,C,D from second table also fine) to get the value for L which is in second table.
Now for this what i need to do join or link the tables or Mapping.. I am not sure.
Can you please help me on this.
Thanks,
Bharat
have you a example . what is the Output ?
You Can create composite key for Fields A,B,C,D in both tables
Now two tables will be connected with Composite key,
Dont forget to use autonumber after creating Composite key for better performance.
Below link gives u the required info..
Hi Asif,
I created a composite key now do i need to use left join and give auto number in second table.
can u please tell me how to do it.
Chk this link.. U will get clear idea...
After u create the composite key, both the tables gets joined with the composite key.. No Joins required separatly..
Tab1:
Load
Autonumber(A&B&C&D) as %key,
..
...
..
K
From ........file;
Tab2:
Load
Autonumber(A&B&C&D) as %key,
L
From ........file;
Now the Both tables will automatically get connected,
You can see in Table viewer
Please find the attached app.
Now can you tell me how can i store this into qvd.
Hi Asif,
I have tried your method.
Can you please tell me how can i store this into qvd.. PFA app.
Store Tablename into Path.qvd(qvd);
Tablename - which table you want to store in QVD
Path - Loaction to store QVD