Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

Data Modelling

Hi,

I'm trying to build data model. I've 280 table and there are some columns in each table. And most of the tables has same column names.

Loaded some ten tables, I see there is a synthetic key table was created. I see there some possible ways to eliminate synthetic key

Renaming fields (Using QUALIFY)

Removing fields


Please let me know which is best possible way to create link between all the tables.

Attaching the file for reference.

Thanks,

Srikanth

5 Replies
Highlighted
Champion
Champion

Re: Data Modelling

did you got any solution !!

Highlighted
Specialist III
Specialist III

Re: Data Modelling

Dear Srikanth,

I would recommended you to create link/bridge table.

Kind regards,

Ishfaque Ahmed

Highlighted
Champion
Champion

Re: Data Modelling

Hi

Ishfaque Ahmed Since from many days you are not active on community ? where are you ?

Highlighted
Master III
Master III

Re: Data Modelling

Please go through below link

Synthetic Keys

What is the use of link table?

Highlighted
Creator III
Creator III

Re: Data Modelling

Try to concatenate most similar tables and create a FACT LESS FACT Table  and then perform the LEFT KEEP on the remaining DIMENSION Tables which will link to FACT and create a STAR SCHEMA.

This method definitely helps and is quite achievable .

Hope this helps

Thanks

CY