Skip to main content

Weave Into Range

The Weave Into Range function weaves a Collection range into the Apply To range, preserving the formatting of each if requested.

The function compares each value in leftmost column of the Collection range to the leftmost column of the Apply To range. When a match is found, the row in the Collection range is placed into the Apply To range based on the Weave Mode setting. If a match is not found, then the location of the closest match is determined. Note that the values of the leftmost column of the Apply To range must be ordered.

Settings

Settings

Weave Mode

This setting determines how the values from the Collection range are written to the Apply To range.

  • Column Insert

    For every row in the Collection range, a row is inserted into the Apply To range regardless as to whether the values in the leftmost column of both ranges match.

    The value of the leftmost cell of the Collection range is copied to the leftmost cell of the inserted row in the Apply To range. The remaining values in the Collection range are copied to the right edge of the Apply To range.

  • Row Append

    For every row in the Collection range, if the value in the leftmost column matches the value in the leftmost column of the Apply To range, the values from the second column outward in the Collection range are copied and pasted to the right edge of the Apply To range.

    If no match is found a row is inserted into the Apply To range, the value from the leftmost column in the Collection range is copied and pasted to the leftmost column of the Apply To range. The remaining columns in the Collection range are copied and pasted to the right edge of the Apply To range.

  • Replace Blanks and Errors

    The values in the Collection range are only copied over blanks and errors in the Apply To range.

    This is most useful when a data connector does not provide a Secondary Server and there are redundant data servers available to retrieve data from and the report should use data from the secondary server if data from the primary is not available.

    In this scenario, two data connections are added into a template. These connections are identical except one is connected to the primary server and the other connected to the secondary. The Apply To range of the Weave Into Range is configured for the range where the primary server data connection is configured and the Collection range for the secondary server. If any values are missing from the primary server connection or return an error symbol (???, ###, @@@ or !!!), the values from the Collection range are woven into the Apply To range.

Use Collection Format

If set to Yes when values are copied from the Collection to the Apply To range, the format from the Collection is pasted with it. Otherwise, the formatting of the Apply To range is used.

Add Grouping

Grouping allows rows or columns to be shown and hidden in a worksheet. When grouping is set on a number or rows or columns a button is added to the left or top that allows you to expand or contract the rows or columns on the sheet. This can be added automatically to the rows or columns of data woven in from the Collection range so that data can be easily shown or hidden within the Apply To data by setting Add Grouping to Yes.

Initial State

If Add Grouping is set to Yes, this setting determines if the Collection data is Expanded or Collapsed when the report is initially generated.

Clear Collection

This setting determines if the Collection range is cleared after the function is complete.

  • None

    The Collection range is not cleared.

  • All

    The Collection range is cleared including any applied formatting.

  • All (extended)

    The Collection range is first extended upwards to detect any headings, then the range is cleared including any applied formatting.

  • Contents

    The contents of the Collection range are cleared. Any formatting applied will remain.

  • Contents (preserve leftmost column)

    The contents of the Collection range with the exception of the leftmost column are cleared. Any formatting applied will remain.

Example

Combine alarm data into process data.

image80.png
image81.png

Apply To

Cell

$B$3:$E$3

Direction

Down

End

All cells are empty

Collection

Cell

$G$3:$H$3

Setting

Value

Weave Mode

Column Insert

Use Collection Format

Yes

Add Grouping

Yes

Initial State

Expanded

Clear Collection

All

In this section: