Release Features


Generating Sample Files for Data Preparation

Citi Bike provides data monthly as zipped comma-separated values (.csv) files that contain the following data values:

  • Trip Duration (seconds) 
  • Start Time and Date
  • Stop Time and Date
  • Start Station Name
  • End Station Name
  • Station ID
  • Station Latitude/Longitude
  • Bike ID
  • User Type (Customer = 24-hour pass or 3-day pass user. Subscriber = Annual Member.)
  • Gender (Zero=unknown; 1=male; 2=female)
  • Year of Birth 

To download a ridership file;

Preparing Data With a Data Flow

Before you load data into your target data source, you can enhance it for your needs. This massaging of the data prior to loading is called data preparation. You can take advantage of the data preparation options to, for example, convert numeric codes to meaningful attributes, discard erroneous data, smooth out ragged data into manageable bins, and blend descriptive data from additional data sources. 

Video: How to Add Static Filters to Your Content

Filters allow you to limit the data that displays in your content to show only the information that is important or relevant to you.  You can create prompted filters, whose values can be selected at run-time, and static filters, which always apply the same value, allowing you to set consistent filter values to your content.
To create a static filter, drag the field that you want to select filter values for to the Filters bucket. You can filter for any field in your data, regardless of whether or not it is used in your content.

Video: New Data Preparation Workflow

Before you load data into your target data source, you can enhance it for your needs in a process called data preparation, which features options allowing you to convert numeric codes into meaningful attributes, discard erroneous data, smooth ragged data out into manageable bins, and blend descriptive data from additional sources. You can also use data preparation calculations to create new fields.

You can access data preparation options when you create a new data flow from the Applications page by clicking New and selecting Flow.

Accessing Document Mode

In Document mode, you can:

  • Build a new document.
  • Open an existing document.
  • Generate a new document from an existing single report.

A blank InfoAssist canvas in Document mode is shown in the following image.

Blank InfoAssist Canvas in Document View

Procedure: How to Access Document Mode to Build a New Document

You can build new documents by accessing Document mode from the InfoAssist splash screen.

Video: New Data Access Workflows

Using WebFOCUS, you can now access all your data from a single streamlined environment. Upload and modify data files, or connect to various data sources, configure adapters, and add or change connections. Then use your data for content creation or further analysis.

It’s easy to upload your data to a target environment.  

From the Home page, click the Get Data button.

Select your file for upload.

You can preview your uploaded data before loading.

Choose from different display and load options. For example, change the number of header rows.