0

I'm building a small blazor wasm app, to help me screening a large amount of data. In the server I have a SQL table that is filled by importing a very large excel, this is done weekly:

table

Then in the app, I need to pivot the data and filter it by latest dates, like this:

table2

I have tried to research SQL pivot, but from what I read, I cannot use it like this, and I cannot change the incoming data format, since it comes from an excel exported from another app, and it is very large!

I hope someone can point me in the right direction, using SQL or entity-framework-core.

Thanks in advance!!

Motorui
  • 47
  • 5
  • Instead of pivoting data in SQL (which usually has some cons -- for example, if you want to have multiple dimensions on axes, or you need totals / subtotals etc) it has a lot of sense prepare pivot table on .NET side. You can try to use this open-source library: https://github.com/nreco/pivotdata (free for non-SaaS apps with a single production deployment). This lib has an extension that may render/export pivot tables just in a few lines of C# code, but this part is a commercial component. – Vitaliy Fedorchenko Jun 06 '21 at 10:32

0 Answers0