Matching more than one column in excel

Help Activities
, , ,
1

I have two excel sheets
Excel A :- Raw Data
Excel B :- Matching data
OutPut Sheet:- For output

Query. :-i wanted to match both the excel A & B and display the output in Output sheet.
but Matching from Excel A need to done with different column i have mentioned the same in Excel B.
and in output i need all the columns of Excel A and Excel B.

Output sheet requires:-(append colums )
only the matched data of both the excels
All the columns of Excel A + All the columns of Excel B.

please help i am really struggling.Excel.zip (21.4 KB)

2

please help anyne

3

Anyone please assist on this

4

ok. So basically we have to pick details from your excel B and give the result found in excel A based on identifier. am i correct?

5

Hi @Sonia_012

Can u give a screenshot of how output should look like?

6

Hi @Sonia_012 ,

You can use something like this:

UiPath
UiPath492Ă—747 33.8 KB

Please find here a starter help: Matching.xaml (7.1 KB)

Best regards,
Marius

7

Hi @nv08

yes correct !! basically

  • Excel A is the raw data and Excel B is the Matched Data from another input File.
    Next step is i need to compare both the files based on the column B and Column C.
    where bot will first filter the “column C” and pick “Name” and the match the data which is in column B with Excel A.
    and output the complete line of Excel A

I hope i am not confusing you!! please let me know if i need to explain more
THank you in advance

1 Like
8

hi @NIVED_NAMBIAR

Please find attached output screenshot. please let me know if i need to explain more
thank you in advance

Data
Data1231Ă—220 36.3 KB

9

Hi @Marius_Puscasu,

Thank you so much but we need comparison in both the excel A and B.

From Excel B =
First Two Line items are matching with Name in Excel A
Next two Line items are matching with Net_Number in Excel A
Next two are matching with Status with Excel A … and so on.

i hope i am not confusing you…
below is the image frm Excel B where in i have highlighted in yellow which are getting matched from Excel A.

Capture
Capture896Ă—220 34.8 KB

10

Main.xaml (12.8 KB)
The task is completed but i am not able to get a clue how to put those in data table. kindly check once and reply if it meet your needs

11

Which is common column in both table ?

12

Hi @Aleem_Khan,

Common column is multiple which is mentioned in ExcelB =“Identifyer From Excel A”

Data
Data1231Ă—220 62.7 KB

13

Hi @Sonia_012 ,

Is this the expected result?

UiPath
UiPath997Ă—72 45.6 KB

If so, please replace the sequence of the input data tables from the Join activity. Please find here the help starter updated: Matching.xaml (7.5 KB)

Best regards,
Marius

14

hi @nv08
yes, thank you so much but i just need one more favor… in output i need to include columns of ExcelB as well
currently you have achieved the matching of Excel A and Excel B…
below is the screen shot for reference…

Data
Data1231Ă—220 36.3 KB

15

so you can create datatable using build data table

16

i am trying to put the result in DT first and then i think i have to use build data table ?? i meant after for each activity.
Main.xaml (12.8 KB)

17

Matching.xaml (10.2 KB)
check this hope this help

18

i think i could not explain you properly. i need to compare first Excel A and Excel B. and the output should have only the matched column.
i request you to please look into the xaml file i have attached. Main.xaml (12.8 KB)

19

this Xaml has the desired output but i am also struggling on below two Points.

  • how to get that in output
  • add all the columns from Excel B on that output

:slightly_smiling_face:

20

Wait I will try to figure out some solution to this.