2つのExcelファイルのNoをもとに1つに集約

kunie · May 17, 2019, 6:44am

下記の２つのExcelを読み込み、Noで合致した結果を1つのExcelファイルにまとめる方法を教えてください

text1.xlsx
No,initial
1,T
2,F
3,Y
4,O

text2.xlsx
Sales,No
220,2
450,4
500,1
,3

結果
No,initial,sales
1,T,500
2,F,220
3,Y,
4,O,450

lakshman · May 17, 2019, 6:47am

You can use Join Data Tables activity for this. Please find the below thread.

kunie · May 17, 2019, 6:49am

I’ll try to refer to the contents of the URL!

system · May 24, 2019, 2:30am

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.