Please suggest best data model for the below tables

[narayanaqlik]

Hi all, Please help me in preparation of best data model which i was mentioned in the attachment code table, Function, Region, Country table are same in left side table and right side tables please find my attachment and give suitable data model advise Thanks in Advance ...

[sumanta1234]

Hi Narayana,

First you have to check which one is your Transaction/Fact table and which one is your Dimension/Master table.

Then you have to find the link between the dimension & fact table.

Qlik will automatically build a data model by creating association between fact & dimension by same field name.