| JoinTwoPagesByMatchingRowLabel |
This function copies selected text columns from another page to the current page, matching row labels between the pages.
Syntax:JoinTwoPagesByMatchingRowLabel, pageRef, tildeDelimitedTextColumnNames Parameters:pageRef – page index or caption of the page to be copied from tildeDelimitedTextColumnNames – tilde-delimited list of the text columns to be copied Examples:AddData,FirstPage.nod PageCaption,FirstPage Adddata,SecondPage.nod JoinTwoPagesByMatchingRowLabel,FirstPage,Plan~Month This example performs a 'lookup' function from the row label in SecondPage and if it finds a matching row label in FirstPage, it copies the text columns Plan and Month.Comments:If there is no matching row labelin the referenced page, the resulting text columns will be empty. Change Historyv4.1 - this is a new command |
Reference
- Functional Index
- AddAggregates
- AddBaseline
- AddData
- AddPage
- AssignCellFormat
- AssignColumnCSS
- AssignWordsToValues
- AssignWordsToValuesSelectedColumns
- AutoPopulateBaselines
- ChangeAlertTo, Axis
- ChangeAlertTo, CellValue
- ChangeAlertTo, None
- ChangeAlertTo, RelativeCell
- ChangeLabelCaption
- ChangePageProperties2
- ChangeTextInTextColumn
- ChangeValuesAboveBelowAggregation
- ChangeValuesPercents
- ChangeValuesToNTile
- ChangeValuesToRank
- ChangeValuesValues
- ClearOldPages
- ClearSelection
- Combine
- CombineDuplicates
- CombineSimilar / ByIndex
- Compare
- CompareSimilar
- ConcatenatePagesWith
- ConcatenateTextColumns
- ConvertAlertsToData
- CopyDataToTextColumns
- CreateTextColumnFromDateColumn
- DeleteTextColumn
- DistributeCellCollection
- Extract
- FilterByValue
- FilterGlobally
- GetCaption
- GetCountsOfValues
- HidePage
- HidePagesExcept
- ImportData
- ImportDataNoHeader
- InvertSelection
- JoinTwoPagesByMatchingRowLabel
- KeepSelected
- MathOperation
- MathOperationOnTwoPositions
- MoveColumns
- MoveColumnValuesToPages
- MoveRowLabelsToPages
- MoveRows
- MoveTextColumnValuesToPages
- NewRowLabel
- NewStartingPoint
- NewTextColumnName
- PageCaption / PageDescription / PageDescriptionAppend
- PageNumericFormat
- ProjectProperties
- Prompt
- PromptForPage
- Query, Captions
- Query, Command / CommandAppend
- Query, CommandTimeout
- Query, Roles
- Query, RowLabel
- Query, Run, ODBC / Oracle / SQL / JDBC
- Query, RunSave, ODBC / Oracle / SQL / JDBC
- Query, TextColumnNames
- RemoveDate
- RemovePage
- RemoveSelected
- RemoveTextColumnsAndDataColumns
- RepeatDataColumnNames
- RepeatingCalculation
- RepeatTextColumnNames
- RepeatTextColumnValues
- Reverse
- RollingPeriods
- RunScript
- SaveAsProject
- SavePageToCSV
- SavePageToCSVPivot
- SavePageToNOD
- SavePageToXMLCrosstab
- SearchAndSelect
- Select, Cell / Unselect, Cell
- Select, Page
- Select,Row/Column Unselect,Row/Column
- SelectByCaptions
- SelectBySpecificPositions
- SelectRange / UnselectRange
- SetCultureString
- SetMath
- SetTupleValue
- ShowAsNumberStandardDeviations
- ShowPage
- Sort
- SortByDate
- SortColumnLabel
- SortCustom
- SortRowLabel
- SortSelected
- SortTextColumn
- SplitTextColumn
- Swap
- SwapCellValues
- SwapTextColumnWithColumn / ByIndex
- SwapTextColumnWithRowLabel / ByIndex
- Test