I have a table contains prjct id,emp id and employee name..etc.. and TABLE 2 with prjct name and employee id
Now i have to link these two tables.based on both project id and EMp id. based on Prjct id it has been linked to other tables .since i need to get the EMployee name in Table 2 i have to link TABLE 1 With TABLE 2.
for some reports to work properly PROJECT ID is also a key between the two.
you need to create a concatenate key, for example if you want to link Table 1 and Table 2 based on prjct id and emp id, you need to create a key which is [prjct id] & ' | ' & [emp id] as PrjcEmpID in both tables, you need to have only one link between two tables.
if you post the whole schema it would be easier to tell.
Great dreamer's dreams never fulfilled, they are always transcended. Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂
