CSV Discovery in Logscape

New in Logscape 3.0

cloud_43-595x553Logscape 3.0 introduces a new feature that makes working with CSV data easier, and faster. Logscape will now automatically generate a datatype from imported CSV data, you’ll be free to immediately build a workspace around your data rather than having to worry about setting up your datatype.

CSV In practice

1)Upload your CSV Data

I used some sport data which you can obtain here, which contained a CSV header-line, and uploaded the Salaries.csv through the user panel. The User panel can be accessed through the right hand navigation menu.

PoLU8r7
Below you can see a small snippet of the CSV data I’m using.


arID,teamID,lgID,playerID,salary
1985,ATL,NL,barkele01,870000
1985,ATL,NL,bedrost01,550000
1985,ATL,NL,benedbr01,545000
1985,ATL,NL,campri01,633333
1985,ATL,NL,ceronri01,625000
1985,ATL,NL,chambch01,800000
1985,ATL,NL,dedmoje01,150000
1985,ATL,NL,forstte01,483333

 

2) Search

Once your data has been indexed, hit search and check the Discovered fields, it will contain all of the fields from your header line, ready for use in building your workspaces and searches. The below search shows the top five average salaries based on team.

gHmZb5h

 

This can be easily modified to show the average player salary across all time

PmPW0Pu

 

Or a sum of how much a team has ever paid.

YjOlqB0

You can easily swap the display format.

O5OMY6b

 

Or concatenate fields, like the below chart does to show year and team.

bQAd6cy

Or average salary per year

NAYFK5J

How does it work

In Logscape 3.0 whenever the .csv file extension is detected Logscape will check if this file has a type assigned, if it does not the first line of the file will be checked for a header line, if the header is found, the field names are extracted, and then your data is mapped against them. These fields are made available in the same way fields of a datatype are available when it is manually created and assigned to a datasource.

In Closing…

We hope that you’ll get use out of this feature, which makes working with CSV data within Logscape just that little bit easier, as always, any questions or ideas please contact us on – support@logscape.com