Skip to main content

Varicent ELT Help Center

Row Viewer

Abstract

Use the Row viewer to preview and create specific columns for your numbers or dates.

Row Viewer is a preview into your data, supporting 500-plus columns, that is always available in your pipe. Use the row viewer to create specific columns for your numbers or dates.

rowViewer2024July.png

  1. Data tab: Displays information from you data set within the Row viewer.

  2. Stats tab: Displays statistics about your data set.

  3. Tool tab: Toggle between your data set and a tool in your pipe to see new insights.

    Note

    This tab is only available with certain data science tools, such as the Predictor, Classifier, and Regressor tools.

  4. Data profile: Display deeper dive into your data set, including column details, correlation and column comparison charts.

  5. Formatting: Arrange your data to your needs with choosing to Modify columns in front, or Preserve native column order.

  6. Download: Save a local copy of your data.

Row viewer format

The Row viewer is a versatile tool to use for your data set.

You can format multiple columns at the same time, simply use the Shift key to select the columns that you want to format.

You can see the total number of rows in your data without counting or opening up the data set with the count on the bottom of the Row viewer.

All data inherits the formatting, either from the data import into Varicent ELT, or if you choose to apply a new format. The filtering option indicates in blue that the filtering is applied. Any new tools that you add in the pipe inherts this format.

Note

Formatting does not carry over to the raw data or appear in the downloaded version (CSV, PDF, PNG) of your data.

The following tools can change the column type, but do not inherit the row viewer from other tools:

  • Adapt

  • Change Type

  • Date Format

You can use reset format to set your data or dates back to the original format.

New columns, default formatting

The following tools add new columns to your data, and come with the default formatting:

  • Moving Average Forecast

  • Forecast

  • Aggregate

  • Binning

  • Combination Matcher

  • Date Add

  • Date Aggregate

  • Formula

  • Quantile

  • Segmentation

  • Classifier

  • Regressor

  • Predictor

  • Running Total/Average

  • Weighted Average

Some tools create a new column called Probability, which is shown as a percentage and has no decimal places.

Numeric Format

Apply the following formats to the rows in your data column:

Table 66. Numeric Format

Format

Description

None

Removes the applied formatting.

Dollar

Adds a dollar sign to the specific column.

Percentage

Adds a percentage sign to the specific column.

Decimal places

Increase or decrease the number of decimal places.



Note

With decimal places, the formatting skips blank rows and starts formatting at the first number in the data.

You can also toggle the 1000's separator on and off.

Important

Calculations with the following five operators generate the output format based on priority:

  • +

  • -

  • *

  • /

  • %

For example, currency > regular number > percentage. If number one is currency and number two is a percentage, number one multiplied by two outputs the currency. If the two operands are set with the same decimal place, the decimal place remains. If the operands are both set with thousand separators, the separators remain. If this is not the case, the decimal places and thousand separators are ignored.

Date Format

There are five date format options to choose from:

Table 67. Date Format

Format

Example

Short Date

21-01-24

Long Date

Monday, January 24, 2001

Time

12:00 AM

Full Date and Time

21-01-24 12:00 AM

Short Month

Jan 2021