Quote from Gaev on February 12, 2020, 8:05 pm

@dglojnar

Here is a description of a Pivot Table ... https://en.wikipedia.org/wiki/Pivot_table ... along with a sample example.

If the number of records (rows) is not huge, a solution using (purely NeoScript commands) can be devised, where the resulting Pivot Table is a database Table ... if interested, please provide ...

- the approximate number of records
- the field in the source table that will be the rows of the Pivot Table
- the field in the source table that will be the columns of the Pivot Table

... any additional information about the expected values in the fields would help make the solution more efficient.

Quote from dglojnar on February 12, 2020, 8:42 pm

@gaev

Thank you very much, things are much clearer now:-)

Problem is in size - tables are ENORMOUS, based on complex SQL query through the 1000's of DB tables (MS SQL) and, in collaboration with report engine, result is importing as pivot table in Excel.

And, not to forget, tables are dynamic, about 10 macros written in VBA running in background.

Macros are simple, easy to recreate with Neobook, so now I have to found a "simple" and good mechanism to change wrong data (mostly format, but there's some more issues...) after macros are finished  and before updating table (1 macro-1 table)

I have a (relative) small table example at home, so now I'm gonna to play with that...

 

Thank you again for your time and effort:-)

Cheers!