Data modeling

[souadouert]

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

[ahaahaaha]

Hi,

In principle, you can download all the files to one by adding an additional field "Category".

Regards,

Andrey

[souadouert]

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

[ahaahaaha]

The pivot table variant will not suit?

[souadouert]

I'm talking about modeling data  and not the reporting phase

[migueldelval · Accepted solution]

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

[souadouert]

Good morning  Miguel

I agree with you, for that I am looking for a solution that respects best practices