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:
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
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!
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
