At SlicingDice we work hard to make our documentation and API simpler and easier to understand and use. This is why we created this interactive column creation tool below.
You can use this tool to better understand how to create any type of column on SlicingDice.
In order to use this tool you only need to add columns and their types in the spreadsheet below and a column creation API command will be dynamically generated for you, based on the columns present on the spreadsheet. If you already have a JSON column creation command and you want to validate if it is correct, paste the JSON below and the spreadsheet will automatically represent your columns.
Data insertion and query demo tool
There are two ways of using this tool: automatic data type identification or manually defining the column's data types.
Automatic data type identification for the column creation using some data on the spreadsheet, as described on the columns auto creation documentation.
- Use the first row of the spreadsheet for the column's names.
- For an event column, you can insert multiple events for the same column, by adding a new line (
Enter) inside the same cell, as shown on the
clicksevent column below. Use this format
New York - 2017-05-09T12:54:12Zto define the value (
New York) and the date/time (
2017-05-09T12:54:12Z) for the event.
- For an attribute column containing a list of values, you only need to insert one value per line, inside the same cell, as shown on the
visited-citiesattribute column below.
- You can also insert new columns and rows in the spreadsheet by right-clicking it.
Adding columns and manually defining their data types, using the second row of the spreadsheet.
- Use the first row of the spreadsheet for the column's name.
- Use the second row of the spreadsheet for the column's API name.
- Use the third row of the spreadsheet for the column's description (optional).
- Use the fourth row of the spreadsheet for the column's data type, that can be one of the values from the list: string, string-event, integer, integer-event, decimal, decimal-event, boolean, date, unique-id or enumerated.
- For an attribute column, use the sixth row of the spreadsheet to define the column's storage, that can either be a
- You can also insert new columns in the spreadsheet by right-clicking it.
Please, select the way you prefer to use this tool using the Tool mode select box below.