Reference
No results for 'undefined'
    Powered by Algolia

    JOIN_FRAMES_CROSS_PRODUCT

    Combines rows from two frames based on their cross product - i.e. matches every record from frame1 with every record from frame2. Frame aliases are used as prefixes for columns in case of name collision.

    Syntax

    =JOIN_FRAMES_CROSS_PRODUCT(Frame1, Frame2, [Frame1 Alias], [Frame2 Alias])

    Parameters

    1. Frame1
      • Type: Frame
      • Description: Frame1
    2. Frame2
      • Type: Frame
      • Description: Frame2
    3. Frame1 Alias [optional]
      • Type: String
      • Description: Frame1 Alias
    4. Frame2 Alias [optional]
      • Type: String
      • Description: Frame2 Alias

    Returns

    • Type: Frame
    • Description: Resulting frame

    Example

    =JOIN_FRAMES_CROSS_PRODUCT(A1, A2, "customers", "orders")

    See Also

    Contents