The problem with merge 2 table in UiPath

Help Documentation
, ,
1

I have 2 table (image below) and I wanna merge it into one table.
Condition: [借入の種類]=[決算期（月数）]⇒the other way: [2016年5月]=[2016年5月(12)]
If: [2018年10月]=[2018年5月(12)] ⇒ not merge data (長期借入,短期借入)
I will try to do like below:

  1. Use excel application scope to read all those two table and use read range to get the datatable…and then merge the datatable I have an option called merge datatable where provide theiput as out_table_1 as source and out_table_2 as destinaton
  2. Finally, use write range to write that datatable to another excel sheet

But before merging them, I dont know how to check condition (index name), so I can’t merge them.
Can you help me, please!
table1
table2

2

Hi @Phuong_Bui

We can’t give condition in merge datatable activity , it will simply append the data into destination datatable

If you want to check index of two datatables means in that case you can go with join datatable activity
kindly refer below image for reference

image
image1366×768 89.1 KB

Thanks,
Robin

1 Like
3

Hi,

Can you try the following sample?

img20220112-4
img20220112-41103×864 35.5 KB

Sample20220112-2.zip (11.2 KB)

Regards,

4

Hi @Robinnavinraj_S
if i use join datable activity, condition is column table 1 (借入の種類) = column table 2 (決算期（月数）) but i think in this case column table 2 (決算期（月数）).contain( column table 1 (借入の種類) )
In the operation, it don’t have function “contain”. Do you have the other way, tell me, please!
Thanks

5

Hi @Yoichi
I will try your way, thanks so much
Regards

6

Hi @Yoichi
Excuse me, can i ask the other question?
Now, data table 1 type is like this:
table1.1

before merge into data table 2, i wanna change data table 1 type to:
table1

Can you help me, please!

Regard

7

Hi,

Do you want to transpose datatable?
There are some activities package support it, as the following.
If you can use custom activity, can you try this?

If not, we need to write logic for it.

Regards,

8

Hi @Yoichi

I 'm useing Uipath Studio Community but in that, it don’t have transpose activity.
What package is transpose activity in?

Regards

9

Hi,

We can get them from Manage Packages - MarketPlace feed as the following.

img20220112-6
img20220112-61008×1040 141 KB

Regards,

10

Hi @Yoichi
I got it, thanks so much

Regards,