Excel Multiple Data

Help Studio
, ,
1

Hi guys,.

I have face some issue here,.
I have two excel file and want to merge both data into 1 data,
The main issue is I need to use 3 data column to merge both data.
Is there any activity I can use to lookup multiple data?

thanks.

2

Hey! Welcome to community!

Yes, If we have the same columns in both the tables we can mere or join the data tables

Regards,
NaNi

3

Hi @THIRU_NANI

As this issue,. they did not have the same column name
it is still consider that I can try to use join datatable?
For example
Excel1
Column1 = CUSTOMER
Column2 = DETAIL
Column3 = PART
Excel2
Column1 = CUSTOMER
Column2 DESCRIPTION
Column3 = PART NO

Thanks

4

Hey!

Yes, Try with Join DataTable->JoinType->Full

Could you please show me the input data?

Regards,
NaNi

5

Hi,
I have a template workflow
Main.xaml (12.3 KB)
Try this method could be helpful.

6

so_inquire_progress_20220609_125029.xlsx (157.0 KB)
inventory_list_20220609_125110.xlsx (84.1 KB)

please refer to the sheet0 on both file
I want to merge all the data but need to follow 3 column.
SO Column J,CA,U
IL Column BO,CG,AT

THanks

7

before merge first use filter data Table and there option is called output columns there you can keep or remove the columns whichever you want and then you can use merge data table

8

Hi @Veera_Raj

Yes, as right know I using filter datatable, only get a column I want
After this process I want to lookup usign 3 column as mention above to find other datacolumn

yhanks

9

you can simply use write range or append for second data table dont read headers just read data only then append

10

HI @Veera_Raj

Im not write data after…
What I want is to
1.lookup those 3column data form excel1 in each row.
2. find it on the Excel2. column Machine, and etc
3. Write on the excel1 on the new column

Thanks