Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Data model issue.

Please look at the attached snapshot, I need Phys_Name in Doctors Table also.

2 Replies
Not applicable
Author

not sure I understand: do you need Phys_name on that table instead of the other one, or do you need to be able to slice data in both tables by that same field? If it's the first, then it should be dead easy using either APPLYMAP or a simple JOIN. If it's the latter, you need a link table in the middle which has the key and the shared attribute.

Not applicable
Author

Hi,

Add this script:

JOIN (Doctors)

LOAD DISTINCT

   DoctorKey,

   phys_name

RESIDENT [ACP Detail Charges];

Regards,

Ricardo