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

[Lakshmanudui]

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

[MayilVahanan · Accepted solution]

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.

[Lakshmanudui]

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.

Thanks & Regards,

Lakshman

[MayilVahanan]

Hi

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