Many times, organizations have different Comma Separated Value (CSV) files that hold pieces of the overall puzzle, but they find it challenging to create a single view to extract meaningful value. For example, there may be separate CSV files for each sales department region and you want to bring them together into a one Workspace for analysis.
Workspaces allow collections of one or more related Comma Separated Value (CSV) files into an Informer Datasource which can be linked, queried, typed, etc. all the same as any other Datasource.
As you import a CSV file into a Workspace, Informer:
- Scans for columns headers
- Intelligently guesses at data type for each column
- Provides the ability for the user to reconfigure the types
- Creates a PostgreSQL table per the document structure.
Once a CSV successfully imports into a Workspace, it exists not as a file but as an actual table in the local Informer PostgreSQL database for data analysis. In this way it is manipulated as any other Datasource. So, as you add associated CSV files into the same workspace, you can create links provided the files contain logical associations.