Excel-Mapping of Data

excel
activities

#1

Hi All,

I am working with two excel files.One is Master Data file.
I need to map data from master excel file to Another file.
In master data file , there are Multiple Columns like Student Name , MarksDailyReport.xlsx (9.1 KB)
MasterSheet.xlsx (8.1 KB)
etc.
In other sheet , I have Student Name column with Data and Marks column is without data for particular student.

Problem is , In master excel file Student Name And Marks columns Having data for 10 students.But for another excel file Marks Column , I need data for Random 5 students.
Other sheet having 5 random Student names , here i need to Map Marks column data from master for particular student.


#2

Take Updated Files for your reference.
MasterSheet.xlsx (8.1 KB)
DailyReport.xlsx (9.1 KB)


#3

Hi @SagarSB,

Can you apply vlookup method, e.g. as shown in this link: https://www.uipath.com/kb-articles/simulate-excel-vlookup-in-a-datatable ?


#4

i m not able to understand it…
can you please design Sequence by using my Excel file??


#5

Hey @SagarSB,

I made you the sequence :slight_smile:
I hope this helps you!

Regards,
Rishabh.


#6

have you made it?

if yes , could you please share it with me??

Thanks in advance.


#7

@SagarSB My bad! :stuck_out_tongue: i thought i already uploaded it!

Here you go!
ResultMapping.xaml (13.3 KB)


#8

You may also check the solution from the thread below:


You would just replace the selector and the formula with the relevant one, like =VLOOKUP(A2,’[MasterSheet.xlsx]Sheet1’!1:1048576,2,FALSE)


#9

Thank you so much


#10

Thanks