Aggregates the values in a numeric column by 2 aggregation-key columns: Pivot table. Sum, Percentage, Count and Average are tabulated as a cross table TSV. Eg, “Sales for each combination of Client-Y and Store-X” is aggregated from “Sales log TSV”.
[su_box title="Master Table, Create by TSV String" style="soft" box_color="#ff99ff" title_color="#000000" radius="0"] Creates a new master file (OptionsXML) by referring to the TSV String. The specified column data are set as Master IDs, and the other data is set as Master Labels. By placing a [Service Task (Choices Update)] in the downstream process, the update task can be automated.[/su_box]