Search: type-into-1

Join Table Wizard - set join condition and join type Properties Input Data Table1 (DataTable

to organize and structure your code better. Eg: Join Data Table\ Option Join Type (JoinType) - INNER/LEFT/FULL. Output Output Data Table (DataTable) - The output in the type of DataTable.

join condition and join type** ** [[image:image-20230419151628-1.png]] == **Properties** == **Input

Table\ **Option** * **Join Type (JoinType)** - INNER/LEFT/FULL. **Output** * **Output Data Table (DataTable)** - The output in the type of DataTable. ))) {{velocity}} #if ($xcontext.action != 'export

Command Type - Specifies how a command string is interpreted. The following options are available: ・Text

-20220506105340-1.png]] (* for Mandatory) == **In the body of activity** == * **Configure Connection **- Set

/Database/Activities/Database%20Connect/WebHome/image-20230419153435-1.png?rev=1.1||alt="image-20230419153435-1.png"]] * **Edit Query** - SQL command to be executed. This field must be completed according

affected by the command. For all other types of statements, the return value is -1. (* for Mandatory

. For all other types of statements, the return value is -1.

and structure your code better. Eg: Execute Non Query Command Type - Specifies how a command string

. For all other types of statements, the return value is -1. [[image:image-20220506105309-1.png

/Database%20Connect/WebHome/image-20230419153435-1.png?rev=1.1||alt="image-20230419153435-1.png"]] * **Edit

Query * **Command Type** - Specifies how a command string is interpreted. The following options

: Output of the activity with type = ‘WindowApp’. Output variable can be used in another Attach Window

and allows you to execute multiple activities inside it. [[image:image-20220505133724-1.png

Active Window **Output** * **Application Window:** Output of the activity with type = ‘WindowApp

Window (WindowApp)* - Output of the activity with type = ‘WindowApp’. Output variable can be used

and execute multiple activities within it. [[image:image-20230417163220-1.png]] (* is mandatory

to organize and structure your code better. E.g: [3424325] Open Window (% class="wikigeneratedid" id="H-1

)*** - Output of the activity with type = ‘WindowApp’. Output variable can be used in another Attach Window

with type = ‘WindowApp’. Misc Public (Checkbox) - Check if you want to public the activity. Remember

] Open Window Output Application Window (WindowApp)* - Output of the activity with type = ‘WindowApp

window and execute activities within the window. [[image:image-20220505133620-1.png]] (* is mandatory

with type = ‘WindowApp’. **Misc** * **Public (Checkbox)** - Check if you want to public the activity

with type = ‘WindowApp’. Output variable can be used in another Attach Window or Use Window property

to attach with type = ‘WindowApp’. X (Int32)* - The new X position of the window. This property supports

. [[image:image-20230417163133-1.png]] (* is mandatory) == **Properties** == **Common** * **Continue On Error

)* **- Input WindowApp for the Attach Window to attach with type = ‘WindowApp’. * **X (Int32)* **- The new X

(WindowApp)* - Input WindowApp for the Attach Window to attach with type = ‘WindowApp’. Misc Public

size and position (The size before it was minimized or maximized). [[image:image-20230417163410-1.png

. **Input** * **Window (WindowApp)* **- Input WindowApp for the Attach Window to attach with type

with type = ‘WindowApp’. Misc Public (Checkbox) - Check if you want to public the activity. Remember

window. [[image:image-20230417163559-1.png]] (* is mandatory) == **Properties** == **Common

)* **- Input WindowApp for the Attach Window to attach with type = ‘WindowApp’. **Misc** * **Public (Checkbox