Comparison in two different excel sheet

Help Activities
, ,
1

Hi Folks,

Facing issue while comparing two excel files (SOurce file and destination file)
After comparison, if new entry found in source file, Update this new entry in destination file in respective columns as column index are not same but column name are same.

This is Source File. Highlighted entries should get add in destination file.
image

Below is Destination file image.

image
image847×313 8.14 KB

Kindly advise.

2

Hi @sayali_gujarathi1,
This is because you need to use a trim method. The Trim method removes from the current string all leading and trailing white-space characters .i.e., yourString.Trim

Hope it helps you!

3

I think this is not I am expecting. Is it something related with my query?

4

Hi @sayali_gujarathi1 ,
Please share the expression that you are using to compare the two values.

5

Hi,
If possible please share input & output file.

Thanks

6

Destination.xlsx (8.5 KB)
Source.xlsx (8.5 KB)

7

Hi @sayali_gujarathi1 ,

Try to use this demo project.
BlankProcess.zip (15.8 KB)

Hope it helps you!