Initializing help system before first use

To Repeat a Table Column for each Element in a Set (pivot table)

You can create a column per element in a set. If you have array entities with two or more index sets you can use vdl-repeat over one of the common index sets and create a column per element.

  1. In the Palette > Components group, click and drag a Table element onto a container on the artboard. Proceed through each page of the Table wizard before clicking Finish.
    In the Table wizard, select the Entity (MY_ARRAY) to be displayed in the Table Column.
  2. Drag the Repeat element onto the Table Column on the artboard. In the Attributes pane, enter the following in the Repeat field: 
    =item in scenario.entities.MY_SET
  3. Select the Table Column on the artboard. In the Attributes pane, set:
    • Heading to "='MY_ARRAY, ' + item.label"
  4. In the Palette > Components group, click and drag an Index Filter element onto the Table Column.
  5. Select the Index Filter element on the artboard, and in the Attributes pane:
    • Edit the Set attribute to select the dataset. ("MY_SET")
    • Edit the Value attribute to specify the value to display in the table column ("=item.value"). 
<vdl-table>
    <vdl-table-column vdl-repeat="=item in scenario.entities.MY_SET" entity="MY_ARRAY"
                    heading="='MY_ARRAY, ' + item.label">
        <vdl-index-filter set="MY_SET" value="=item.value"></vdl-index-filter>
    </vdl-table-column>
</vdl-table>
Parent Topic The vdl-repeat attribute

© 2001-2020 Fair Isaac Corporation. All rights reserved. This documentation is the property of Fair Isaac Corporation (“FICO”). Receipt or possession of this documentation does not convey rights to disclose, reproduce, make derivative works, use, or allow others to use it except solely for internal evaluation purposes to determine whether to purchase a license to the software described in this documentation, or as otherwise set forth in a written software license agreement between you and FICO (or a FICO affiliate). Use of this documentation and the software described in it must conform strictly to the foregoing permitted uses, and no other use is permitted.