Discussion board where members can get started with QlikView.
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)
Please let me know which is best possible way to create link between all the tables.
Attaching the file for reference.
did you got any solution !!
I would recommended you to create link/bridge table.
Ishfaque Ahmed Since from many days you are not active on community ? where are you ?
Please go through below link
What is the use of link table?
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