Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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
Like all tables on something such as Year Month and use joins to help optimize your model and remove synthetic tables
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