Join Data Tables

Last modified by VuNH54 on 2023/04/19 15:16

RCA.Activities.Core.JoinDataTables

Description

This activity allows you to add different data from different tables using common values with each other.

join data table.jpg

(* is mandatory)

In the body of activity

Join Table Wizard - set join condition and join type 

image-20230419151628-1.png

Properties

Input

  • Data Table1 (DataTable)* - The first table that you want to use in the Join operation, is stored in a DataTable variable. This field supports only DataTable variables.
  • Data Table2 (DataTable)* - The second table that you want to use in the Join operation, is stored in a DataTable variable. This field supports only DataTable variables.

Misc

  • Public (Checkbox) - Check if you want to publicize it. Remember to consider data security requirements before using it.
  • Display Name (String) - The name of this activity. You can edit the name of the activity 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.
  
Navigation