VA Table Editor - https://gitlab.sas.com/Joao.Oliveira/va-table-editor

[Joao-deOliveira]

For those that are interested on editing tables directly within VA, the VATableEditor is available for download on GitLab.sas.com Project: https://gitlab.sas.com/Joao.Oliveira/va-table-editor

It allows to do changes at the cell level. Also provides multiple other functionalities like:

• Header Filtering (in addition to the VA report filtering linked to the DDC object)
• Cell content select from:
  • another cell
  • from another cell via lookup another table for a value. it's possible to combine with a formula
  • from another table,
  • from column values it self ... this also available for Header Filtering
  • from a provided list of values (simple or label => value)
• Cell content can be calculated by a formula. This applies to all column types (numeric, date, time, datetime, strings)
• Add rows by duplicating a existing row and/or a defaulted row
• Table Pagination
• No limit on columns nor rows (the only limits are the ones imposed by VA)
• Applying a value to an entire column (respecting the filtering) with the possibility to Rollback
• Changes History (Undo / Redo). Applies to cell changes, row adding and/or deleting
• Table content validation (cell by cell). Invalid cells log (with printing possibility) and violations exposed on cell tooltip
• Table exporting data to multiple formats
• Ability to export to Clipboard > apply changes > reimport table
• Application log export
• All Changes traceability registering in a tracing table. This at cell level detail including all details about the change made.
• Saving the changes on CAS Table and/or persist those changes on physical table.
  • Three way of controlling:
  • 1) combined saving in memory and persisting |
  • 2) save in memory and asking if to persist |
  • 3) save in memory, persisting in a separated action
• Ability to call internal SAS Viya Services (like JobExecution) and 3rd party WebServices, in background or foreground, passing information (like the row UID)
• In version 4.4: Column aggregation values. Two different aggregations are possible, one the top and/or other on the bottom. Function include the most common statistical ones.

Enjoy :-)

[rluppi]

@Joao-deOliveira, I'm afraid the external community doesn't have access to gitlab.sas.com