Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
good morning
I have several qvd files(20) that designate a product for exemple(Insurance, credit, convention), the files have some columns with the same name but not the same values. So I opted to group products by category, is what you choose to group all the files in a same table or each category in a table.
I am looking for the most logical and optimal solution in terms of perfermoonce
Hi Souad,
I think that you don´t need to agrupate all your info in a table, because performance are going to be worst.
It´s better to use Qualify/UnQualify and make a link table with the category.
Performance and Optimization Best Practices in QlikView & Qlik Sense
More advanced topics of qlik datamodels
Regards
Miguel del Valle
Hi,
In principle, you can download all the files to one by adding an additional field "Category".
Regards,
Andrey
Yes, I have already coded this solution, but I'm doing my internship at the end of the study so i have to have a design that meets the standards of business intelligence
The pivot table variant will not suit?
I'm talking about modeling data and not the reporting phase
Hi Souad,
I think that you don´t need to agrupate all your info in a table, because performance are going to be worst.
It´s better to use Qualify/UnQualify and make a link table with the category.
Performance and Optimization Best Practices in QlikView & Qlik Sense
More advanced topics of qlik datamodels
Regards
Miguel del Valle
Good morning Miguel
I agree with you, for that I am looking for a solution that respects best practices