How should join rules be specified in a join data table?

[shirata.motoki]

For datatable-type variables dt1 and dt2, where I want to join them using the email column, how should I write the filter builder?
My current approach did not work properly. Could someone please help? Thank you in advance.
By the way, I’m using studioweb instead of studio.

[prashant1603765 (Prashant Kumar)]

Hi @shirata.motoki
Welcome to UiPath.

Use the Join Data Tables activity to merge two tables, setting dt1 as the first input and dt2 as the second input. In the activity properties, select Full Join as the join type to ensure all rows from both tables are included, even if no matching values are found.
Open the Filter Builder and define the join condition by selecting the Email column from dt1, using the = operator, and selecting the Email column from dt2. This ensures that records with matching Email values are merged while unmatched rows from both tables are retained with null values in missing fields.
Assign the output to dt_Joined to store the combined result for further processing.

If you found helpful mark as a solution.
Happy Automation with UiPath.

[Yoichi]

Hi,

In my environment, it works well as the following. Can you share error message etc. if you have?

Regards,

[pikorpa (Piotr Kołakowski)]

Hey @shirata.motoki
Welcome to our forum
If you want to join dt1 and dt2 based on the email column, you can use the Join Data Tables activity, which is available in Studio Web.
Set dt1 as the first table, dt2 as the swcond table, type of joining and specify email as the common column in join rules.

[Yoichi]

Hi,

From your screenshot, the column name might contain extra double quotes.

So, can you try to input the column name with double quote from not TextBuilder but Expression Editor as the following?

Regards,

[shirata.motoki]

ありがとうございます、皆さんのご指摘通りにして対応出来ました。
理解のため追加で可能であればお伺いしたいのですが、
左側では「“”」で文字列?として入力を行い、
右側ではexpression editor内で「“”」を使用して宣言するとうまく動く理由は何でしょうか?
よろしくお願いします。

[Yoichi]

@shirata.motoki

左側では「“”」で文字列?として入力を行い、
右側ではexpression editor内で「“”」を使用して宣言するとうまく動く理由は何でしょうか?

仕様としてあまり良くは無いと思いますが、
左辺のテキストフィールドに直接入力した場合、（もともとテキストビルダーの選択肢もないので）Expression Editorでの入力と同様として扱われます。
一方右辺は、テキストビルダーが優先されるようで、テキストフィールドの直接入力はテキストビルダーでの入力となってしまいます。

上記のような使用のため、テキストフィールドへの直接入力は避け、どのエディタで入力するかを明示的に選択して、値をセットしたほうがより良いかと思います。