How to compare column values from two different tables and if they match then paste the value present in the first excel sheet into another

[sandeepbht96 (Sandeep Bhat)]

how to map the names present in fist excel sheet with the names present in second excel sheet and paste the value present in first excel sheet into another.

example:
First Excel
Name Value
Sandeep 50
Arshad 65

Second Excel
arshad
Sandeep

data is present
now i have to compare the names from two excel sheets and paste the value according to mapped values.

Please help.
Regards,
sandeep

[ronanpeter]

This should give you what you need

Write to a Particular Cell if Value is a match

So if you have your DataTable of ServiceIDs/IDs taken from the XML data it should look something like this: ID ServiceID 16 175 22 190 So you want to essentially do a vlookup between the two datatables. There are a number of ways to achieve this and you should monitor performance if your dataset is large. However, for me, this is the easiest. Just read in both datasets and use the Lookup DataTable Activity - The CSV datatable lookups up the XML datatable to return a ServiceID, if…

[varunk (Varun Kumar)]

Hi @sandeepbht96,

Use select for mapping of two columns
one is is in excel1
& another is in excel2

[sandeepbht96 (Sandeep Bhat)]

@varunk can you please send an example of how to do that

[varunk (Varun Kumar)]

Hi @sandeepbht96,

For example
Excel1 & excel2 are there,I need to map the two excels with one column in each
First read excel1 & excel2 store as dt1 & dt2
In which excel you want to write data,in for each row give that data table
take one assign & create one variable for that row
Then take another data table
dt2.Select(“[Colum Name]='”+variable Name+“'”)

[ronanpeter]

As linked. This takes two datatables (one of each sheet of the attached excel), performs a vlookup and brings across the required values to the target datatable.

Sequence.xaml (11.3 KB)

Input.xlsx (9.1 KB)

[Abubakkar (vnrabu)]

Here same problem accured. Could you tell me
where can I mistake this workflow.
I need help to find solution Main.xaml (710.8 KB)
SAPLEVEL3.xlsx (11.3 KB)
for your references

[ronanpeter]

@Abubakkar you have not set the column to target

[Abubakkar (vnrabu)]

Hi, @ronanpeter
Thanks for your answer.
Can you tell me how to set the column to target?

[ronanpeter]

You need to set the name or index in one of the overload groups, as the error message says.

[Abubakkar (vnrabu)]

yeah, I found it. Thanks @ronanpeter.
But again it seems like this
what kind of error this?
Main.xaml (689.4 KB)
This is my Updated one.

[Abubakkar (vnrabu)]

Main.xaml (784.0 KB)

Now it’s working Thanks @ronanpeter