Creating a cBase From a Text File

In this demonstration, you'll learn how to create a columnar database (cBase) from a text file in Dimensional Insight’s Workbench integrated development environment.

What we'll cover: 

• Understanding the conversion of text file columns into dimensions and summary columns in ProDiver

• Procedure for generating a Spectre build script and adjusting it for specific data processing needs

• Analyzing and modifying column types in the script to match the data

• Saving changes to the Build script and executing it to create the cBase

• Validating the output in ProDiver and ensuring correct data representation

• Adjusting column types and re-running the script for optimal results

• Reviewing the cBase in ProDiver to confirm all data appears as intended

See also:

• Workbench Help > Creating cBases with Spectre Build Scripts

• Workbench Help > Spectre Build Text Input