Search: add-data-column

RCA.Activities.Excel.ExcelInsertColumnsTable Description Adds a specified column at a certain

want to insert. E.g: "Table1" Column name (String) - Name of column you want to insert. E.g: "Column1" Properties Input Column name (String) - Name of column you want to insert. E.g: "Column1" Position (Int32

Excel Insert Columns Table

" %) ((( RCA.Activities.Excel.ExcelInsertColumnsTable == **Description** == Adds a specified column at a certain position in the table. [[image:image

)** - Table name you want to insert. E.g: "Table1" * **Column name (String)** - Name of column you want to insert. E.g: "Column1" == **Properties** == **Input** * **Column name (String)** - Name of column you

にカスタム列を追加することもできます。データセットにカスタム列を追加するには、次の手順を実行します。 1.BusinessDatasetページで、｢Add Column｣ボタンを選択してカスタム列を追加

でカスタム列を使用するには、既存のダッシュボードを編集モードで開きます。 1.｢Data Source｣を選択します。 1.｢jhi_dataset｣テーブルを検索し、それをデータ

で、**｢Add Column｣**ボタンを選択してカスタム列を追加します。 1.表示されるダイアログで、カスタム列の名称とデフォルト値を入力します。 (% class="box infomessage

** == 1.ダッシュボードでカスタム列を使用するには、既存のダッシュボードを編集モードで開きます。 1.**｢Data Source｣**を選択します。 1.**｢jhi_dataset｣**テーブルを検索

[1] ROI data set

add custom columns to the Business Dataset. To add a custom column to the dataset, do the following: On the Business Dataset page, select the Add Column button to add a custom column. In the dialogue that pops up

decimals. 4. Click Enter to save the workflow value. Adding Custom Columns to the Business

[1] ROI data set

add custom columns to the Business Dataset. To add a custom column to the dataset, do the following: 1. On the **Business Dataset** page, select the **Add Column** button to add a custom column. 1

. Click **Enter** to save the workflow value. == **Adding Custom Columns to the Business Dataset

-package Add Delete Column: Adds blank columns or removes existing columns from a specified sheet. Add Delete Rows: Adds empty rows or removes existing rows from a specified sheet. Add New Sheets: Creates

a range of cell data (Range) from a specified workbook (Workbook) worksheet (SheetName). Delete Sheet

: === **1.  Sheets sub-package** === (% class="box" %) ((( * Add Delete Column: Adds blank columns or removes existing columns from a specified sheet. * Add Delete Rows: Adds empty rows or removes existing rows from a specified sheet. * Add New Sheets: Creates a new sheet inside a specified Google

the structured text. This activity enables you to select column and row separators according to which the table

(default) - blocks the process from continuing the execution. Fixed formatting options Column Sizes (IEnumerable< Int32 >) - Specifies the size of the columns that are to be created in the table. This field

Generate Data Table

generate data table.jpg

Data Table

Generate Data Table

(String)*** - The field that you add unstructured data to convert into a table. Only String are supported

. This activity enables you to select column and row separators according to which the table is generated. [[[[image:generate data table.jpg||class="img-thumbnail"]]>>attach:generate data table.jpg]] (* is mandatory

a specified CSV File. (* is mandatory) In the body of activity File Path (String) - You can add the file

of the CSV file E.g: “C:\CSVFolder\clientList.csv” Misc Public (CheckBox) - If you check it, the data of this activity will be shown in the log. Be careful, consider data security before using it. Display Name (String

Path (String)** - You can add the file path of the CSV here. String supported only. == **Properties

” **Misc** * **Public (CheckBox) **- If you check it, the data of this activity will be shown in the log. Be careful, consider data security before using it. * **Display Name (String) **- The name of this activity

DataTable to a CSV File. (* is mandatory) In the body of activity File Path (String) - You can add the file path of the CSV here. String supported only. Data Table (DataTable) - Specifies the DataTable to be written in the CSV file. Properties Input Data Table (DataTable)* - Specifies the DataTable

** == * **File Path (String)** - You can add the file path of the CSV here. String supported only. * **Data

” * **Add Headers (CheckBox)** - Boolean that specifies if the column names from the DataTable will be added

** == **Input** * **Data Table (DataTable)*** - Specifies the DataTable to be written in the CSV file

will be shown as below: No Panel Description 1 Add new trigger Click here to create a new trigger 2 Edit

the information in the tab: Basic No Column/Label Description Type Maximum Is Mandatory? 1 Trigger Name Fill

the information in the tab: Action No Column/Label Description Type Maximum Is Mandatory? 1 Action type Choose

;" %)Description |1|(% style="width:264px" %)**Add new trigger**|(% style="width:816px" %)Click here to create

.png||height="358" width="342"]] (% style="width:1043px" %) |=No|=Column/Label|=Description|=Type

.png||height="432" width="409"]] (% style="width:1043px" %) |=No|=Column/Label|=Description|=(% style

for. This field supports only strings and String variables. Eg: “Name of column” Data Column (DataColumn

and String variables. Eg: “Name of targeted column” Data Column (DataColumn) - Specifying a DataColumn

and the column specified in the Target Column property category. (* is mandatory) Properties Input Lookup

Look Up Data Table

look up data table.jpg

Data Table

Look Up Data Table

in the Target Column property category. [[[[image:look up data table.jpg||class="img-thumbnail

to search for. This field supports only strings and String variables. Eg: “Name of column” * **Data Column

. Eg: “Name of targeted column” * **Data Column (DataColumn)** - Specifying a DataColumn variable here

: “Column name here”. Data Column (DataColumn) - The variable containing the column you want to sort

RCA.Activities.Core.SortDataTables Description This activity allows you to sort data tables in ascending or descending order, based on the values of a specified column. (* is mandatory) Properties

Sort Data Table

sort data table.jpg

Data Table

Sort Data Table

" %) ((( RCA.Activities.Core.SortDataTables == **Description** == This activity allows you to sort data tables in ascending or descending order, based on the values of a specified column. [[[[image:sort data table.jpg||class="img-thumbnail

: “Column name here”. * **Data Column (DataColumn)** - The variable containing the column you want to sort