Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Read about the latest Qlik Community enhancements on the Community News blog!
cancel
Showing results for 
Search instead for 
Did you mean: 
Lakshmanudui
Contributor II
Contributor II

How to handle data model if four tables having same common field name

Hi All,

I have four tables and four tables having same common field name.

How to handle data model.

See below example for reference.

for example 

Student details table:

Student ID, Student Name, Student address

Student Course Details table:

Student ID, Course, Category

Student Marks:

Student ID, Marks

Student Status:

Student ID, Status, Grade

Above four tables having Student id is common.

 

Can you please suggest me how to handle data model.

 

Thanks & Regards,

Lakshman

1 Solution

Accepted Solutions
MayilVahanan

HI

Qlik will handle the data model based on common field.

In your case,  You can load the 4 tables alone in the script, studentId is common, so Qlik will take care of it.

Thanks & Regards,
Mayil Vahanan R

View solution in original post

3 Replies
MayilVahanan

HI

Qlik will handle the data model based on common field.

In your case,  You can load the 4 tables alone in the script, studentId is common, so Qlik will take care of it.

Thanks & Regards,
Mayil Vahanan R

View solution in original post

Lakshmanudui
Contributor II
Contributor II
Author

Hi Mayilvahanan,

Thanks for your replay.

My Data model is forming Below image wise.

Qlik will take care of data or will do any changes.

Lakshmanudui_0-1627872152625.png

 

Thanks & Regards,

Lakshman

MayilVahanan

Hi

Now, all tables are linked with each other. so that, you can proceed based on ur requirement. 

Thanks & Regards,
Mayil Vahanan R