Review Data From Imported Excel/CSV

NonPlayerCharacter

I am currently working with a large set of imported excel/csv data and I need a way to review this information within Decisions. I am currently looking into using Advanced Data Grids but I am not sure where to begin. Do you have any suggestions?

Nathan_Decisions

Absolutely. The attached sample project demonstrates how to import a CSV/Excel and utilize the data within an Advanced Data Grid within the Form to visualize the data. The CSV To List Mapping Step takes in excel data and maps the columns into a previously created database structure, Employee.

Finally, the Advanced Data Grid within report is sourced from the Employee database structure with the data fields corresponding to the columns in the Test.xlsx file.

Documentation

Advanced Data Grids: https://documentation.decisions.com/docs/advanced-data-grids

Data Grid vs Advanced Data Grid: https://documentation.decisions.com/docs/differences-between-data-grids-and-advanced-data-grids

Project:

Data Grid Example Project-09072024-051455.zip

Please Note: The examples attached were developed to be instructional, and were not developed as officially supported components. For more information or to engage our service team to develop fully supported, production quality solutions, please contact: services@decisions.com.