Help us build a better product, earn the PaxPro Advocate badge: Six short questions, one cool badge.

Visit the official Paxata Documentation portal for all of your doc needs.

Paxata Fundamentals

All the fundamental things you need to know about using Paxata once you know the basics. Brand new to Paxata? Check out the "Getting Started" section first.
 

Discussion List

  • Using the Split operator
    Splitting a column involves taking the values in a single column and distributing them into one or …
    103 views 0 comments Started by Akshay
  • Trimming leading and trailing whitespace
    (Image) This operation, when applied to a column, examines all rows for spaces at both the beginn…
    21 views 0 comments Started by Akshay
  • Find + Replace
    (Image) The Find + Replace function allows you to find specific values in a column and replace t…
    51 views 0 comments Started by Akshay
  • Collapse Consecutive Whitespace
    This operation examines all text strings in a column for all instances of two or more spaces in suc…
    1 view 0 comments Started by Akshay
  • The Lookup function
    The LOOKUP function allows the user to combine a selected dataset as a lookup table to the previous…
    112 views 0 comments Started by Akshay
  • Columns
    Paxata allows the user to specify which columns within a dataset are visible at specific points in …
    31 views 0 comments Started by Akshay
  • Compute
    The COMPUTE button allows you to add a column to your data set using any number of functions to com…
    234 views 0 comments Started by Akshay
  • Publish
    The Publish function allows the you to publish your updated dataset into the Data Library for use i…
    1 view 0 comments Started by Akshay
  • Tags
     (Image) The top portion of the Data Library contains a number of filters, which can be used to v…
    11 views 0 comments Started by Akshay
  • Steps Editor
    The Steps Editor allows you to view, edit, add, rearrange, and delete steps within a project. The S…
    2 views 0 comments Started by Akshay
  • Remove function
    The REMOVE function allows you to remove rows from your data. In order to use the REMOVE function, …
    21 views 0 comments Started by Akshay
  • Aggregate: Variance (Var)
    Estimates the how much dispersion exists (how much the values are spread out) within a sample set o…
    11 views 0 comments Started by Akshay
  • Aggregate: Sum
    This aggregate function executes an addition operation on the numbers in the reference column (the …
    11 views 0 comments Started by Akshay
  • Aggregate: Standard Deviation (stdev)
    Estimates the standard deviation (how much variation from the average) exists within a sample set o…
    11 views 0 comments Started by Akshay
  • Project Lenses
    Lenses are used to create publishing points from Steps in your Project. When you publish from a Len…
    101 views 0 comments Started by Akshay
  • Importing a fixed-width file
    When you import a fixed-width file, click the dropdown box next to the file name on the right hand …
    1 view 0 comments Started by Akshay
  • Aggregate: Max
    This aggregate function returns the largest of the numbers in the reference column (the column to w…
    1 view 0 comments Started by Akshay
  • Aggregate: First
    The First function searches the data for duplicate rows (based on the columns chosen by the user) a…
    1 view 0 comments Started by Akshay
  • Aggregate: Count
    This aggregate function returns the number of duplicate rows in a dataset. Excluding the column to …
    11 views 0 comments Started by Akshay
  • Aggregate: Average
    This aggregate function finds an average of the numbers in the reference column (the column to whic…
    1 view 0 comments Started by Akshay
  • Aggregate: Array
    Of the available aggregate functions available, array is unique in that it operates on both text an…
    12 views 0 comments Started by Akshay
  • Aggregate Functions
    The following is a list of the Aggregate Functions available to the user during Group By and Pivot …
    31 views 0 comments Started by Akshay
  • Shape (Group By)
    This function allows for the user to utilize a number of different aggregate functions (listed belo…
    62 views 0 comments Started by Akshay
  • Shape (Transpose)
    Transpose is the simplest of the Shape functions, essentially allowing you to switch your rows and …
    63 views 0 comments Started by Akshay
  • Shape (Pivot)
    Pivot is similar to transpose in that it allows you to rearrange your column headers into row heade…
    94 views 0 comments Started by Akshay
  • Shape (Depivot)
    The Depivot function is a very powerful function that allows you to take your data and stack column…
    31 views 0 comments Started by Akshay
  • Shape (Deduplicate)
    The Deduplicate function searches your data for rows that match each other exactly, and condenses t…
    91 views 0 comments Started by Akshay
  • Import Options: Microsoft Excel
    Any of the most common Excel® file types can be uploaded in their native formats directly into the …
    81 views 0 comments Started by Akshay
  • Answerset Versions in the Library
    Each time you publish an Answerset from a project, a version of the answerset is created and previo…
    1 view 0 comments Started by Akshay
  • Intro to using Lookups
    this is a placeholder for a future article.
    1 view 0 comments Started by CSDan