Identify the function of the Pivot transformation
Answer(s): A
A pivot transformation is one way to transform data from a tall/skinny format to a short/wide format. The data is distributed into columns, usually aggregating the values. This means that multiple values from the original data end up in the same place in the new data table. A pivot transformation requires selecting row identifiers, column titles, values and aggregation methods, and optionally transfer columns and aggregation methods12. The function of the pivot transformation is to pivot row values into columns of data, based on the chosen parameters34.
Pivoting Data - TIBCO SoftwareDetails on Pivot Data - TIBCO SoftwareTransforming Data - TIBCO SoftwareTransforming Data - TIBCO Software
Transforming an underlying Data Table from Short/Wide to Tall/Skinny format is known as
Answer(s): B
Unpivoting is a transformation method that changes the data table from a short/wide format to a tall/skinny format. This means that multiple columns are combined into one or a few columns, and the number of rows increases accordingly. Unpivoting can be useful when you want to analyze the distribution of data across different categories or values, or when you want to apply other transformations or calculations on the data. Unpivoting can be done either when loading data or after the data has been loaded into Spotfire. To unpivot data, you need to select which columns to keep as they are (category columns) and which columns to merge into one or more value columns (value columns). You can also specify the names of the new columns and the data types of the value columns.
Unpivoting Data, Transforming Data, Spotfire Tips & Tricks:Normalize/Standardize your data with Spotfire
Which custom expression function is used by when you auto-bin a numeric column?
AutoBinNumeric() is a custom expression function that is used when you auto-bin a numeric column. This function creates a binned column where the value range is divided into intervals based on the number of unique values and the distribution of the data. The function takes one argument, which is the column to bin, and returns a string column with the bin labels. The function is equivalent to right- clicking on a column selector and selecting Auto-bin Column, which creates a temporary, automatic binning on an axis. The function can be used in custom expressions to create permanent binned columns or to apply binning to other visualizations.
AutoBinNumeric, How to Use Binning
Which of the following binning functions can be used on a numeric type column?
Answer(s): C
BinByEvenDistribution() is a binning function that creates a binned column where each bin has the same number of unique values as the others. The last bin may have more unique values than the others. The first argument is the column to bin and the second argument is the number of bins. This function can be used on a numeric type column to group the values into equal frequency bins. The other binning functions are either not valid (BinByTimeSpan(), BinByNumbers()) or not applicable to a numeric type column (BinByDateTime(), BinBySubstring()).
Binning Functions, How to Use Binning
The Expression shortcut "Cumulative Sum" uses which expression?A)B)C)D)
The expression shortcut "Cumulative Sum" uses the expression Sum([Column]) THEN Sum([Value]) OVER (AllPrevious([Axis.X])). This expression calculates the sum of the values in a column, and then calculates the cumulative sum of those values over all previous values on the X-axis. This is equivalent to option C in the image you sent1.
Cumulative Sum
Post your Comments and Discuss Tibco TCP-SP exam prep with other Community members:
Our website is free, but we have to fight against AI bots and content theft. We're sorry for the inconvenience caused by these security measures. You can access the rest of the TCP-SP content, but please register or login to continue.