Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Srinivas
Creator
Creator

How can i create Data model based on my Excel

Hi All,

How to create Data Model Based on my screen shot,

Please suggest me as soon as i waiting very eagerly to your replay.

Advance & Thanks

Munna

4 Replies
Not applicable

Hi Munna,

Create a data model by loading each tab as a single table and by linking those fields as per your business requirement like Country, Year or month fields.

Kumari.

Srinivas
Creator
Creator
Author

Hi Kumari,

I created same based on Year link.

but here have country and LOB also same fields in all tabs.

We can add all tabs into one table.

Regards

Munna

Not applicable

Like all tables on something such as Year  Month and use joins to help optimize your model and remove synthetic tables

datanibbler
Champion
Champion

Hi Munna,

adding (concatenating?) all tabs into one table would be difficult as you have a lot of specific fields, thus that one table would have a lot of blank fields.

If, like here, you have fields with the same name, but different contents, between different tables, you can avoid the automatic linking QlikView does by renaming the fields (either qualify them with the table name, but that can be tricky, I would not suggest to do so, or just use the AS option and enter another name.

HTH

Best regards,

DataNibbler