Map data excel

[fairymemay (noona)]

I want to map data from master file and write it in another file as below.
(map row ID from row Type in master file and insert column Type in output file (in column C)

Guide me about it please.

master.xlsx (10.0 KB) input2.xlsx (9.2 KB) outputExcel.xlsx (9.6 KB)

[NIVED_NAMBIAR (NIVED N)]

Hi @fairymemay

So u need to get the value of Type corresponding to ID in the master file and put in output file?

is it right?

[fairymemay (noona)]

@NIVED_NAMBIAR yes.

[Marius_Puscasu]

Hi @fairymemay ,

One simple solution is to use the Lookup Data Table activity (https://docs.uipath.com/activities/docs/lookup-data-table ) as within the following example:

This is the helper file: MapDataExcel.xaml (7.6 KB)

Hope this helps!
Best regards,
Marius

[fairymemay (noona)]

@Marius_Puscasu If I have 5000 rows in master.
It run long time.

Guide me please

[Marius_Puscasu]

Hi @fairymemay ,

I’m afraid that it doesn’t matter to much on how many rows are in master.
It depends a lot by how many rows are within the input files (here you have the For Each Row loop).

Please let us know how much time it takes now?

Also, please check the Hardware and Software Requirements (https://docs.uipath.com/installation-and-upgrade/docs/robot-hardware-and-software-requirements). I think it might impact the performance as well.

Best regards,
Marius

[fairymemay (noona)]

@Marius_Puscasu I try input file data have 1 rows , master 5000 rows.
10 minutes ago not finished.

[Marius_Puscasu]

Hi @fairymemay ,

I’ve tested a similar workflow read range (1 row input + a master file of 12000+ rows) & lookup data table and it took 3 seconds to return the searched value.

I’m afraid that the issue either with the HW or SW resources or somewhere else within your workflow

Best regards,
Marius