Introducing Firefly Semantics CSV

Firefly Semantics CSV or FS CSV is a tool for:

• Checking CSV Files for Parser Errors
• Checking that key values are defined
• Checking that key values or compound key values are unique
• Assembling CSV data from multiple files

Firefly Semantics CSV Data Integration Help Center

Demo

Login in and try it out.

Firefly Semantics CSV Application Integration

Detecting Parser Errors

This file has fields without corresponding headers.

LOCATION, SKU  
Chicago,  FS1
Boston,   FS2,     42, 42

When loaded it will generate the error seen in the screenshot:

Parser Errors

Defined Key Values Check

In this file a valid SKU value is missing from the row containing Philadelphia as the city.

LOCATION,    SKU
Chicago,     FS1
Boston,      FS2
Philadelphia,

We want to detect this so we load the file, check off SKU as a column that has key values. Then click PROCESS . This is the result:

Undefined Key Values

Duplicate Key Value Check

This file as row duplicates.

LOCATION, SKU
Chicago,  FS1
Boston,   FS2
Chicago,  FS1
Boston,   FS2

We load it and check off LOCATION and SKU as key values. Hit PROCESS and this is the result:

The result shows which rows are duplicates according to the key values selected.

Data Assembly

We have the following files:

CSV1.csv

LOCATION, SKU, FORECAST
Chicago,  FS1,    2
Boston,   FS2,    3

CSV2.csv

LOCATION, SKU, STOCK
Chicago,  FS1,    10
Boston,   FS2,    10

We want to combine them so we end up with this:

LOCATION, SKU, FORECAST, STOCK
Chicago,  FS1,    2,       10
Boston,   FS2,    3,       10

So we load both files and select LOCATION and SKU as keys and we also select the headers we want in the result.

If you made it this far thanks for reading up and staying with us! We hope you will try our app and we hope you love using it as much as we liked creating it.

Brought to You By Firefly Semantics

Firefly Semantics Supply Chain and Big Data Analytics for the Cloud